Re: how to find log

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