Re: How to get previous log file

On 6/28/20 2:42 AM, Andrus wrote: Hi! select pg_read_file(pg_current_logfile()) retrieves today log file. Log files are in log directory: /var/lib/postgresql/12/main/log# ls ... postgresql-2020-06-08_00.log  postgresql-2020-06-18_00.log postgresql-2020-06-28_00.log postgresql-202

How to get previous log file

Hi! select pg_read_file(pg_current_logfile()) retrieves today log file. Log files are in log directory: /var/lib/postgresql/12/main/log# ls ... postgresql-2020-06-08_00.log postgresql-2020-06-18_00.log postgresql-2020-06-28_00.log postgresql-2020-06-09_00.log postgresql-20