Where are PostgreSQL logs stored?

Better Stack Team
Updated on October 5, 2023

PostgreSQL stores logs in the log files. Depending on your system, you can find the logs at the following locations:

Ubuntu

On Ubuntu and Ubuntu-like systems, the PostgreSQL log is stored in the /var/log/postgresql directory.

OSX Homebrew

On latest OSX Homebrew, logs are stored at /opt/homebrew/var/log/postgres.log

Make your mark

Join the writer's program

Are you a developer and love writing and sharing your knowledge with the world? Join our guest writing program and get paid for writing amazing technical guides. We'll get them to the right readers that will appreciate them.

Write for us
Writer of the month
Marin Bezhanov
Marin is a software engineer and architect with a broad range of experience working...
Build on top of Better Stack

Write a script, app or project on top of Better Stack and share it with the world. Make a public repository and share it with us at our email.

community@betterstack.com

or submit a pull request and help us build better products for everyone.

See the full list of amazing projects on github