Re: log file - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: log file
Date
Msg-id 20050120022108.GA96923@winnie.fuhr.org
Whole thread Raw
In response to log file  ("Keith Worthington" <keithw@narrowpathinc.com>)
List pgsql-novice
On Wed, Jan 19, 2005 at 07:32:02PM -0500, Keith Worthington wrote:

> I have a client application that is unable to write to the database.  I
> suspect a permission problem.

What is the client trying to do?  How did you determine that it's
not working?  Client libraries should have a way to check an
operation's success or failure, and most should provide a way to
get an explanatory error message for a failed operation.  What
language does the client application use?

> Is there a log file that shows the commands that the server is
> executing?  Where should I start to look for it and what controls
> where it is written?  Is there a way to increase/decrease the logging
> level while I am troubleshooting?

See the "Run-time Configuration" section of the "Server Run-time
Environment" chapter in the documentation, especially the "Error
Reporting and Logging" section.

> I am running PostgreSQL v8rc5 on RedHat Enterprise Linux v3.

Some PostgreSQL RPMs redirect the server's logs to /dev/null, so
you might want to check the PostgreSQL startup script if you installed
an RPM.  I don't know if the 8.0.0 RPMs have that problem, though.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-novice by date:

Previous
From: Akbar
Date:
Subject: password authentication always failed
Next
From: Akbar
Date:
Subject: grant all the database object automatically