'Where are the postgres logs?

I'm using DBeaver to connect the postgres db and want to access the logs via DBeaver.

I run the command below to find log destination and got stderr as the location.

show log_destination ;

How can I reach that file on DB app? FYI, I want all logs, not the logs that are from DBeaver.

postgresqldbeaver


Solution 1:[1]

On recent PostgreSQL versions, that is simple:

SELECT  pg_current_logfile();

For old versions, proceed as follows:

  • Verify that the logging collector is started:

    SHOW logging_collector;

    • If not, the location of the log depends on how PostgreSQL was started.

    • If yes, the log will be in log_directory:

      SHOW log_directory;

      If that is a relative path, it is relative to the PostgreSQL data directory.

Since the log file is on the database server, you probably won't be able to access it with a client tool.

Solution 2:[2]

https://tableplus.com/blog/2018/10/how-to-show-queries-log-in-postgresql.html#:~:text=The%20location%20of%20the%20log,pgsql%2Fdata%2Fpg_log%2F%20.

In Ubuntu is under /var/log/postgresql

Solution 3:[3]

You can run pg_lsclusters.

> pg_lsclusters                                                                                                          
Ver Cluster Port Status Owner    Data directory              Log file
11  main    5432 online postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1
Solution 2 Mark
Solution 3 Krishna

Related Questions