Where are the PostgreSQL logs on macOS?

protoboolean picture protoboolean · Apr 1, 2010 · Viewed 54.4k times · Source

I would like to take a look at the PostgreSQL log files to see what my app writes to them but I can't find them.

Any ideas?

Answer

Mikko Ohtamaa picture Mikko Ohtamaa · Jun 20, 2015

On OSX Homebrew installation the log can be found at:

/usr/local/var/log/postgres.log 

or for older version of postgres (< 9.6)

/usr/local/var/postgres/server.log