Django virtual environment, where are the logs of Postgres saved in mac?

Question

I have a Django project running in virtual environment(in MAC OS), where can I access the postgres logs? Before asking this question,I have looked into following posts but I could not find logs in the places they suggest * http://www.postgresql.org/docs/9.0/static/runtime-config-logging.html * How to check status of PostgreSQL server Mac OS X * http://www.postgresqlformac.com/server/error_startup_fails_after_i.html * Where are the PostgreSQL logs on Mac OS X?

Answer 1

1. You may find it using the following command:

   sudo find / -name pg_log
   

   Output:

   /Library/PostgreSQL/9.2/data/pg_log
   

2. If the above attempt fails, try to find log location in your plist

   My plist is located at /Library/LaunchDaemons/, another possible location is /Library/LaunchAgents/.

   Check if com.edb.launchd.postgresql-9.2.plist contains the following section:

   <dict>
     ......
     <key>StandardErrorPath</key>
     <string>/usr/local/var/postgres/server.log</string>
   </dict>
   

   In the above case, the log is located at /usr/local/var/postgres/server.log