Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've got a PostGIS NHD layer thats not rendering in mapnik (using toposm code scripts) and I don't know why.

I've confirmed that the table data is there, positioned correctly and has the proper projection via QGIS, and the styles seem to have the table names correctly, but I'm still getting a features layer without my nhd water features.

Is there a way I can tell mapnik.render to spit out the queries its running against my PostGIS db? Is there another way to debug this?


share|improve this question
up vote 1 down vote accepted

Yes, you can build Mapnik to enable all postgres queries details to be output. See for more details.

However, it is easiest to just enable logging of postgres itself. One way that I frequently do this is to launch postgres from the command line like:

postgres -D /path/to/postgres/directory -c log_min_duration_statement=0

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.