Hi Theo, yes you can log every SQL statement. Just edit the postgresql.conf and delete the remark (#) from the following line: #log_statement = false
Then restart postgres. After this you can find every statement in the postgresql.log. On Gentoo you can find this log in /var/lib/postgresql/data. But keep in mind that logging every statement takes a lot of time. Best regards Lutz On Wed, 22 Sep 2004 15:51:35 +1000 Theo Galanakis <[EMAIL PROTECTED]> wrote: > > Is there a log file, or a method of logging all the SQL statements a > postgres server processes. I can look at pg_stat_activity which tells me > each postgres process and the current query running, however I wanted to see > a log file, similar to SQL Servers Profiler, where I can capture all the SQL > being run. I guess I could write some external process to poll the > pg_stat_activity and collect current processors and SQL commands being run. > > Theo > -- Lutz Steinborn mailto:[EMAIL PROTECTED] 4c AG Tel +49 6092 999592 Stefan-George-Ring 22-24 Fax +49 89 99341 399 81929 M�nchen http://www.4c-shopping.de http://www.wohndesign.de http://www.wohnen.de ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
