Hello,
I'm migrating some shapefiles using FME to a PostgreSQL/PostGIS database.
Is there any way to monitor all of the SQL commands that have been sent to it during the translation ?
Thank you.
Solved
Setting up a trace on a PostgreSQL database from shapefile migration
Best answer by david_r
There are several tutorials out there, including this one, that shows how to do it:
http://www.microhowto.info/howto/log_all_queries_to_a_postgresql_server.html
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- Best Answer
There are several tutorials out there, including this one, that shows how to do it:
http://www.microhowto.info/howto/log_all_queries_to_a_postgresql_server.html