|
|
 | | From: | Keith Worthington | | Subject: | log file | | Date: | Wed, 19 Jan 2005 19:32:02 -0500 |
|
|
 | Hi All,
I have a client application that is unable to write to the database. I
suspect a permission problem. 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? I am running PostgreSQL v8rc5 on RedHat
Enterprise Linux v3.
Kind Regards,
Keith
______________________________________________
99main Internet Services http://www.99main.com
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
|
|
| | From: | Michael Fuhr | | Subject: | Re: log file | | Date: | Wed, 19 Jan 2005 19:21:08 -0700 |
|
|
| 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/
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
|
|
|
