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)
duringtroubleshooting. 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
Messagesto 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