need suggestion
Hello,
I have an application already running, accessing the database (postgresql
8.1). I need a solution, that prints (on a file, or somehow) the queries
being executed every time the app accesses the database.
Is there any ON DATABASE ACCESS trigger ?!
Any idea how that can be done?
Thanks in advance.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/need-suggestion-tp5728154.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
kostika gorica wrote:
I have an application already running, accessing the database
(postgresql
8.1). I need a solution, that prints (on a file, or somehow) the
queries
being executed every time the app accesses the database.
Is there any ON DATABASE ACCESS trigger ?!
Any idea how that can be done?
If you set log_statement='all', all statements will be logged.
You could use the log file.
Yours,
Laurenz Albe
Thanks a lot. I didn't know that type of log existed :)
--
View this message in context: http://postgresql.1045698.n5.nabble.com/need-suggestion-tp5728154p5728169.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.