Re: Need to place pgpool logs on separate directory

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

Thanks & Regards,
Rajamohan.J

On Thu, Nov 12, 2020 at 9:41 AM Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> 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
>