Search Postgresql Archives

Re: Loging of postgres requests

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 created by
> the application generating invalid SQL or if there is a problem with the
> desgin of the database tables.
>
> Dave.
See:
http://www.postgresql.org/docs/8.2/interactive/runtime-config-logging.html
In particular you will want to set log_statement to 'all'  to see the SQL.
-- 
Adrian Klaver
aklaver@xxxxxxxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux