Re: Loging of postgres requests

[Terry Fielder <terry@xxxxxxxxxxxxxxxxxxxx>]

You can turn up the verbosity of postgres logger to log all SQL statements.  Look in postgresql.conf

In particular, you can set postgres to log statements that take over x milliseconds to execute.  If you set log_min_duration_statement to 0, then it will log ALL statements, which could also give you what you want if you want to see all SQL statements.

Terry

Terry Fielder
terry@xxxxxxxxxxxxxxxxxx
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085

Dave Potts wrote:

I am using a 3rd front end to generate  postgres requests , its reportng an error with the database.

Is there anyway of loging which sql requests the application is  actual sending to postgres.  I need to known if the error is being created by the application generating invalid SQL or if there is a problem with the desgin of the database tables.

Dave.