1) Check the log file
postgres=# show data_directory ;
data_directory
-------------------------
/u02/PostgreSQL/10/data
(1 row)
postgres=# show log_directory ;
log_directory
---------------
log
(1 row)
postgres=#
postgres=# show log_filename ;
log_filename
--------------------------------
postgresql-%Y-%m-%d_%H%M%S.log
(1 row)
postgres=#
postgres=# select pg_current_logfile();
pg_current_logfile
--------------------------------------
log/postgresql-2021-10-24_000000.log
(1 row)
No comments:
Post a Comment