[pgpool-hackers: 3971] Re: Proposal: Refactor configuration parameters
Tatsuo Ishii
ishii at sraoss.co.jp
Thu Jul 15 07:11:19 JST 2021
I have committed those patches into master branch. Also I tweak
pgpool_setup so that pgpool and PostgreSQL uses milliseconds
timestamps for logging. This is also for master branch only.
> And documentation patch...
>
>> 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
More information about the pgpool-hackers
mailing list