[pgpool-hackers: 3944] Re: Proposal: Refactor configuration parameters

Tatsuo Ishii ishii at sraoss.co.jp
Sat Jul 3 14:51:05 JST 2021


Bo Peng said:
> However, pgpool doesn't support "%m" option (time stamp with milliseconds).
> I would like to make pgpool support "%m" option. 

So I wrote a patch to implement "%m" of log_line_prefix. Below is the
sample output when log_line_prefix is set to "'%m: %a pid %p: '". If
there's no objection, I would like to commit this in master branch.

2021-07-03 13:58:37.799: main pid 28135: LOG:  Backend status file /home/t-ishii/work/Pgpool-II/current/x/log/pgpool_status discarded
2021-07-03 13:58:37.799: main pid 28135: LOG:  health_check_stats_shared_memory_size: requested size: 12288
2021-07-03 13:58:37.799: main pid 28135: LOG:  memory cache initialized
2021-07-03 13:58:37.799: main pid 28135: DETAIL:  memcache blocks :64
2021-07-03 13:58:37.799: main pid 28135: LOG:  allocating (136588088) bytes of shared memory segment
2021-07-03 13:58:37.799: main pid 28135: LOG:  allocating shared memory segment of size: 136588088 
2021-07-03 13:58:37.891: main pid 28135: LOG:  health_check_stats_shared_memory_size: requested size: 12288
2021-07-03 13:58:37.891: main pid 28135: LOG:  health_check_stats_shared_memory_size: requested size: 12288
2021-07-03 13:58:37.891: main pid 28135: LOG:  memory cache initialized
2021-07-03 13:58:37.891: main pid 28135: DETAIL:  memcache blocks :64
2021-07-03 13:58:37.897: main pid 28135: LOG:  pool_discard_oid_maps: discarded memqcache oid maps
2021-07-03 13:58:37.904: main pid 28135: LOG:  Setting up socket for 127.0.0.1:11000
2021-07-03 13:58:37.910: main pid 28135: LOG:  find_primary_node_repeatedly: waiting for finding a primary node
2021-07-03 13:58:37.941: main pid 28135: LOG:  find_primary_node: primary node is 0
2021-07-03 13:58:37.941: main pid 28135: LOG:  find_primary_node: standby node is 1
2021-07-03 13:58:37.941: sr_check_worker pid 28175: LOG:  process started
2021-07-03 13:58:37.942: health_check pid 28176: LOG:  process started
2021-07-03 13:58:37.942: pcp_main pid 28174: LOG:  PCP process: 28174 started
2021-07-03 13:58:37.942: health_check pid 28177: LOG:  process started
2021-07-03 13:58:37.945: main pid 28135: LOG:  pgpool-II successfully started. version 4.3devel (tamahomeboshi)
2021-07-03 13:58:37.945: main pid 28135: LOG:  node status[0]: 1
2021-07-03 13:58:37.945: main pid 28135: LOG:  node status[1]: 2
-------------- next part --------------
A non-text attachment was scrubbed...
Name: log_line_prefix.diff
Type: text/x-patch
Size: 1398 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-hackers/attachments/20210703/818be1fc/attachment.bin>


More information about the pgpool-hackers mailing list