Re: [GENERAL] Loging of postgres requests

2008-03-15 Thread Dave Potts
Thanks everbody I have isolated the issue Davel, Terry Fielder wrote: 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_d

Re: [GENERAL] Loging of postgres requests

2008-03-15 Thread Terry Fielder
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 gi

Re: [GENERAL] Loging of postgres requests

2008-03-15 Thread Adrian Klaver
On Saturday 15 March 2008 2:29 pm, 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 cre

[GENERAL] Loging of postgres requests

2008-03-15 Thread Dave Potts
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 th