[postgis-users] connection logging

[Jason Thaxter]

>From Postgres 7.4 on, you can turn on query logging per-connection like this:
   mydb=> SET log_statement=true;

This would be very useful for examing problems with  PostGIS queries
in mapfiles, whether speed or parsing issues. Of course, I can't
figure out how to get the above query statement to work inside a
mapfile - kind of a catch-22 there.

Has anyone done this?

We have a busy development server, so turning on log_statement in
postgresql.conf isn't a useful solution