I am trying to create a Mapnik layer based on a PostGIS table, and I keep getting an error message when trying to load the layer
Postgis Plugin: ERROR: relation "public.myTable" does not exist ...
. This is my first time working with PostGIS and I've gotten Mapnik working with other layer types, but I was wanting to experiment with the possibility of using PostGIS.
I created the table I'm trying to use with QGIS, and I can see the table inside of QGIS in the database manager and through psql.
This is what my layer definition looks like in Mapnik
<Layer name="myLayer" srs="+init=epsg:4326"> <StyleName>My Style</StyleName> <Datasource> <Parameter name="type">postgis</Parameter> <Parameter name="host">localhost</Parameter> <Parameter name="dbname">postgis</Parameter> <Parameter name="user">postgres</Parameter> <Parameter name="password">[password]</Parameter> <Parameter name="table">public.myTable</Parameter> <Parameter name="estimate_extent">true</Parameter> </Datasource> </Layer>
myTable. I've tried uppercase, lowercase, and actual case.
Why is Mapnik failing to load this table?