Trever Adams <trever_Adams@bigfoot.com> writes:
>> Try looking in the
>> postmaster log --- the error message should be logged there as well.
>> Knowing what the backend is trying to tell us would be helpful...
> Ok, this is going to sound very dumb: Where is this log kept? Is it
> kept through syslogd? If so, I apparently have it turned off
> somewhere.
With the default configuration of Postgres, this logfile is just the
postmaster's stderr output --- that should be getting put into a file
somewhere, if you are using recommended procedures for starting the
postmaster. ~postgres/server.log is the usual place.
I think it is possible to redirect the postmaster log to syslogd, but
you have to specifically configure things that way to make it happen.
regards, tom lane