Re: logging messages this time - Mailing list pgsql-novice

From Tom Lane
Subject Re: logging messages this time
Date
Msg-id 5153.1067444099@sss.pgh.pa.us
Whole thread Raw
In response to logging messages this time  ("Eric S. Johansson" <esj@harvee.org>)
Responses Re: logging messages this time  ("Eric S. Johansson" <esj@harvee.org>)
List pgsql-novice
"Eric S. Johansson" <esj@harvee.org> writes:
> ... I'm trying to get logging working so I can observe
> more closely what is failing and make a more appropriate diagnosis.

Turning on log_connections and log_statement certainly ought to produce
more output than you are getting.  I wonder if maybe you are editing the
wrong copy of postgresql.conf --- people have made that mistake before.
The right copy is the one in the PGDATA directory (-D postmaster argument).
Don't forget that you need to either SIGHUP or restart the postmaster to
get it to take notice of changes in postgresql.conf.

            regards, tom lane

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump bug?
Next
From: Josh Berkus
Date:
Subject: Re: foxpro to postgresql 7.x