On 06/25/2012 02:50 PM, Stefan Schwarzer wrote:
> Craig Ringer wrote:
I'm puzzled about why you don't appear to be looking at the server error logs (/usr/local/pgsql-9.1/data/pg_log) during troubleshooting. They're your main source of info.
Hmm, I guess it's because I didn't think of it, I was't really aware of it (although I tried to use the Console Error Messages to find any errors), and wouldn't have been sure how to access it (as it belongs to the _postgres user). But then, it doesn't exist. I see pg_clog and pg_xlog...
Perhaps your install places it somewhere else. Sorry, I don't really do
mac. The PostgreSQL log directory can be found by examining
postgresql.conf in the data directory. The 'log_directory' parameter
specifies where Pg writes its logs to.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general