Re: Need to place pgpool logs on separate directory

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: garajamohan(at)gmail(dot)com
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Need to place pgpool logs on separate directory
Date: 2020-11-12 04:11:30
Message-ID: 20201112.131130.1138451602594614224.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message RAJAMOHAN 2020-11-12 05:25:41 Re: Need to place pgpool logs on separate directory
Previous Message Michael Lewis 2020-11-11 23:47:02 Re: identify partitioning columns and best practices of partitioning in prod enviornments