Re: how to find log

Thanks Tom, Andrew
I’ll try out logging_collector facility

thanks again

dm

> On Dec 20, 2020, at 12:04 PM, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
>
>
> On 12/20/20 11:31 AM, Tom Lane wrote:
>> Dmitry Markman <dmarkman(at)mac(dot)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
>