Re: Loging of postgres requests

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_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@greatgulfhomes.com
> 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.
>> ------------------------------------------------------------------------
>>
>>
>>