[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