Where postgresql logs are on mac os x?

Question

I would like to take a look to postgresql log files to see what my app tells him but I can't find them.

Any ideas?

Answer 1

Look in /var/log/pg_log/ folder

Answer 2

Just ask your database:

SELECT 
    * 
FROM 
    pg_settings 
WHERE 
    category IN( 'Reporting and Logging / Where to Log' , 'File Locations')
ORDER BY 
    category,
    name;

In my case, it's in "/Library/PostgreSQL/8.4/data/pg_log"

Answer 3

On OS X, if you're using the EnterpriseDB installation of PostgreSQL, your log files will be in /Library/PostgreSQL/8.4/data/pg_log

Of course, you'll want to substitute 8.4 for whichever version number you're running.