Обсуждение: 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.