Thanks for the feedback Chris, 1. I am successfully, query the table from postgres sql editor 2. I don't know what code/statement that I can use from python to verify that I can query/grap the data from postgres database. (although, I do know that if I change the table name in osm.xml, it will prompt error in postgres sql log. And if, I put the correct table name in osxm.xml, it will not prompt error. So, seems like it is connecting. however, I am not sure if it is grapping the data or not)
Would you mind give me a little code example, how to connect to database and return the data? I want to verify if it is the problem in data not returning. Thanks so much On Wed, Jan 28, 2009 at 12:20 AM, Chris Jones <roller...@sucs.org> wrote: > > On 28 Jan 2009, at 00:26, John3478 John3478 wrote: > > I am still stuck in rendering zoom level 8 to 16. >> 1. From postgres sql log, I can see if I modify the table name in osm.xml, >> it will prompt table not found. So, it seems like it able to connect to >> database. but I am stuck why it is not able to render any data from >> database. looks like its only get data from boundary. >> -----also in the postgres log file >> ------------------------------------------------------ >> %t LOG: could not receive data from client: No connection could be made >> because the target machine actively refused it. >> %t LOG: unexpected EOF on client connection >> >> ------------------------------------------------------------------------------------------------ >> >> Do you guys know what is the problem? (it is in windows environment) (Iam >> able to run demo from the shape file just fine) >> - PostgreSQL 8.3 , postgis 1.3.5 >> - python 2.5 >> - mapnik 0.5.1 >> >> I try to figure it out, is it still the database problem not able to >> return the data or it is the osm.xml stylesheet that I need to troubleshoot. >> > > Can you connect and grab data from the tables as the user your asking > mapnik to use? > -- > Chris Jones, SUCS Admin > http://sucs.org > > >
_______________________________________________ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
