Translate

Sunday, September 14, 2014

Enabling SQL trace on PostgreSQL 9.3 (on 64 bit Windows 7)

Edit C:\Program Files\PostgreSQL\9.3\data\postgresql.conf  and update the following values

#log_statement = 'all'
#log_min_error_statement = error


Restart the service postgresql-x64-9.3






Now you can see all the SQL queries against postgreSQL DB in

C:\Users\<username>\AppData\Roaming\postgresql\pgadmin_histoqueries.xml




No comments:

Post a Comment

Comments will appear once they have been approved by the moderator