Thanks Tatsuo for the info. I will contact pgpool forum regarding this.
Also I tried restarting and reloading the pgpool service after each of the above parameter changes, still it's not working.
item | value | description
--------------------------------------+--------------------------------------------------------------------+---------------------------------------------------------------------------------
--------------------------------------+--------------------------------------------------------------------+---------------------------------------------------------------------------------
log_destination | stderr | logging destination
logdir | /data/pgpool | PgPool status file logging directory
syslog_facility | LOCAL0 | syslog local faclity
syslog_ident | pgpool | syslog program ident string
syslog_ident | pgpool | syslog program ident string
Thanks & Regards,
Rajamohan.J
On Thu, Nov 12, 2020 at 9:41 AM Tatsuo Ishii <ishii@xxxxxxxxxxxx> wrote:
> Hello all,
>
> I want to place pgpool logs on a separate directory rather than in a syslog
> file. So I changed the below parameters, but still logging information are
> being written to the syslog file. Any idea or suggestion why this
> behaviour?
>
>
>
> *pgpool-II version 4.1.4 (karasukiboshi)*
>
> Tried all the below combinations, none of them works
>
> 1.
> log_destination = 'stderr'
> syslog_facility = 'LOCAL0'
> syslog_ident = 'pgpool'
> logdir = '/data/pgpool'
>
> 2.
> log_destination = 'stderr'
> #syslog_facility = 'LOCAL0'
> #syslog_ident = 'pgpool'
> logdir = '/data/pgpool'
>
> 3.
> log_destination = 'syslog'
> syslog_facility = 'LOCAL0'
> syslog_ident = 'pgpool'
> logdir = '/data/pgpool'
1 or 2 should work. You might want to check whether 'stderr' is
actually set to log_destination parameter by using psql:
pgpool show log_destination;
If it's set but still logs are sent to syslog, try reloading or
restarting pgpool.
By the way this is not the most appropriate forum to ask questions
regarding pgpool. Please use pgpool-general mailing list instead:
https://www.pgpool.net/mailman/listinfo/pgpool-general
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
