[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