[postgis-users] connection logging

[Paul Ramsey]

try setting DEBUG to TRUE in your mapfile and read the mapserver log 
file instead. I think we log SQL when DEBUG is on.

Jason Thaxter wrote:

>>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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users