in your postgresql.conf file near the bottom you need to enable statement logging -- set log_statement = 'all' and then you can tail -f /var/logs/postgresql/postgresql.log or tail -f wherever your postgres log is... from the 'Nix command line "Matthew Peter" <survivedsushi@xxxxxxxxx> wrote in message news:20051005074002.27199.qmail@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx > There a way to watch queries execute on the pgsql > server as queries come in from the network and are > processed? > > Thanks > MP > > > > __________________________________ > Yahoo! Mail - PC Magazine Editors' Choice 2005 > http://mail.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
