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'
Thanks & Regards,
Rajamohan.J
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
Thanks & Regards,
Rajamohan.J
On Thu, Nov 12, 2020 at 9:41 AM Tatsuo Ishii <ishii@sraoss.co.jp> wrote:
Show quoted text
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