how to find log

Dmitry Markman <dmarkman@mac.com> writes:

suppose I started the server with the following command
pg_ctl -D . . . start -l <logfilename>
is there a way to get <logfilename> later by sending some query to the server or

No, the server has no way to know where its stdout/stderr were
pointed to. You might want to enable the syslogger output method
(see logging_collector) to have something a bit more featureful.

https://www.postgresql.org/docs/current/runtime-config-logging.html

regards, tom lane

On 12/20/20 11:31 AM, Tom Lane wrote:

Dmitry Markman <dmarkman@mac.com> writes:

suppose I started the server with the following command
pg_ctl -D . . . start -l <logfilename>
is there a way to get <logfilename> later by sending some query to the server or

No, the server has no way to know where its stdout/stderr were
pointed to. You might want to enable the syslogger output method
(see logging_collector) to have something a bit more featureful.

https://www.postgresql.org/docs/current/runtime-config-logging.html

Alternatively, asking the OS in many cases will work, e.g. on my linux
machine:

ls -l /proc/{postmasterpid}/fd/1

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

Thanks Tom, Andrew
I’ll try out logging_collector facility

thanks again

dm