Thanks Tom, Andrew I’ll try out logging_collector facility thanks again
dm > On Dec 20, 2020, at 12:04 PM, Andrew Dunstan <and...@dunslane.net> wrote: > > > On 12/20/20 11:31 AM, Tom Lane wrote: >> Dmitry Markman <dmark...@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 >
