Thread: Need to place pgpool logs on separate directory

> 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

> 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

When log_destination = stderr, you need to start pgpool with -n option
and redirect stderr to log file. Othewise log will not write to the
log file because without -n stderr is closed.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp