<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:courier,monaco,monospace,sans-serif;font-size:12pt">
<div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">Thanks Martin<br><br>Based on what you said I copied the contents of the <span style="font-family: courier,monaco,monospace,sans-serif;">/usr/include/postgresql to /usr/include and ........ scons found the library. You can see below that I had copied it to /usr/lib but obviously that was wrong. <br><br>Since i am on Ubuntu I modified the osm.xml with<br> <Layer name="text" status="on" srs="+proj=merc +datum=WGS84 +k=1.0 +units=m +over +no_defs"><br> <StyleName>text</StyleName><br> <Datasource><br> <Parameter name="type">postgis</Parameter><br> <Parameter name="host">/var/run/postgresql</Parameter><br> <Parameter name="port">5432</Parameter>
<br> <Parameter name="user">gis</Parameter><br> <Parameter name="dbname">gis</Parameter><br> <Parameter name="table">planet_osm_point</Parameter><br> <Parameter name="estimate_extent">true</Parameter><br> </Datasource><br> </Layer><br><br>I ran python generate_tiles.py as root while running postmaster with -i -D /mnt/postdata -d 5 . I could see straight away that there was activity. <br><br><span><a target="_blank" href="http://www.lukulu.com/map/tilesv3.htm">http://www.lukulu.com/map/tilesv3.htm</a> . Just Paris, France for now.</span><br><br>Thanks allot for all your help.<br><br>Diarmuid<br></span><br>Here is a list of all the libpq* on my machine<br><span style="font-family:
courier,monaco,monospace,sans-serif;">/usr/include/postgresql/internal/libpq</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/include/postgresql/internal/libpq-int.h</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/include/postgresql/libpq-fe.h</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/include/postgresql/libpq</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/include/postgresql/libpq/libpq-fs.h</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/lib/libpq.a</span><br style="font-family:
courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/lib/libpq.so.3</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/lib/libpq.so.4</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/lib/libpq.so</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/lib/libpq.so.3.1</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/lib/libpq.so.4.1</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/lib/libpq-fe.h</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span
style="font-family: courier,monaco,monospace,sans-serif;">/usr/lib/internal/libpq</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/lib/internal/libpq-int.h</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/lib/libpq</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/lib/libpq/libpq-fs.h</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/doc/libpq-dev</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/doc/libpq3</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family:
courier,monaco,monospace,sans-serif;">/usr/share/doc/libpq4</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/doc/postgresql-doc-8.1/html/libpq.html</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/doc/postgresql-doc-8.1/html/libpq-async.html</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/doc/postgresql-doc-8.1/html/libpq-build.html</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/doc/postgresql-doc-8.1/html/libpq-cancel.html</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family:
courier,monaco,monospace,sans-serif;">/usr/share/doc/postgresql-doc-8.1/html/libpq-control.html</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/doc/postgresql-doc-8.1/html/libpq-copy.html</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/doc/postgresql-doc-8.1/html/libpq-envars.html</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/doc/postgresql-doc-8.1/html/libpq-example.html</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/doc/postgresql-doc-8.1/html/libpq-exec.html</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family:
courier,monaco,monospace,sans-serif;">/usr/share/doc/postgresql-doc-8.1/html/libpq-fastpath.html</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/doc/postgresql-doc-8.1/html/libpq-notice-processing.html</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/doc/postgresql-doc-8.1/html/libpq-notify.html</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/doc/postgresql-doc-8.1/html/libpq-pgpass.html</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/doc/postgresql-doc-8.1/html/libpq-pgservice.html</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family:
courier,monaco,monospace,sans-serif;">/usr/share/doc/postgresql-doc-8.1/html/libpq-ssl.html</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/doc/postgresql-doc-8.1/html/libpq-status.html</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/doc/postgresql-doc-8.1/html/libpq-threading.html</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/locale/cs/LC_MESSAGES/libpq3.mo</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/locale/de/LC_MESSAGES/libpq3.mo</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family:
courier,monaco,monospace,sans-serif;">/usr/share/locale/es/LC_MESSAGES/libpq3.mo</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/locale/fr/LC_MESSAGES/libpq3.mo</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/locale/hr/LC_MESSAGES/libpq3.mo</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/locale/it/LC_MESSAGES/libpq3.mo</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/locale/nb/LC_MESSAGES/libpq3.mo</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family:
courier,monaco,monospace,sans-serif;">/usr/share/locale/pt_BR/LC_MESSAGES/libpq3.mo</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/locale/ru/LC_MESSAGES/libpq3.mo</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/locale/sl/LC_MESSAGES/libpq3.mo</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/locale/sv/LC_MESSAGES/libpq3.mo</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/locale/tr/LC_MESSAGES/libpq3.mo</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family:
courier,monaco,monospace,sans-serif;">/usr/share/locale/zh_CN/LC_MESSAGES/libpq3.mo</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/usr/share/locale/zh_TW/LC_MESSAGES/libpq3.mo</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/var/cache/apt/archives/libpq-dev_8.1.10-0ubuntu0.6.06.1_i386.deb</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/var/cache/apt/archives/libpq3_1%3a7.4.12-3_i386.deb</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/var/cache/apt/archives/libpq4_8.1.10-0ubuntu0.6.06.1_i386.deb</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family:
courier,monaco,monospace,sans-serif;">/var/lib/dpkg/info/libpq-dev.md5sums</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/var/lib/dpkg/info/libpq-dev.list</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/var/lib/dpkg/info/libpq3.list</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/var/lib/dpkg/info/libpq3.md5sums</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/var/lib/dpkg/info/libpq3.postinst</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/var/lib/dpkg/info/libpq3.postrm</span><br style="font-family:
courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/var/lib/dpkg/info/libpq3.shlibs</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/var/lib/dpkg/info/libpq4.list</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/var/lib/dpkg/info/libpq4.md5sums</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/var/lib/dpkg/info/libpq4.postinst</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family: courier,monaco,monospace,sans-serif;">/var/lib/dpkg/info/libpq4.postrm</span><br style="font-family: courier,monaco,monospace,sans-serif;"><span style="font-family:
courier,monaco,monospace,sans-serif;">/var/lib/dpkg/info/libpq4.shlibs</span><br><br><div> </div>NOTICE: The information contained in this e-mail message and any attached files may be confidential information. If you are not the intended recipient, any use, disclosure or copying of this e-mail and any attached files is unauthorised. If you have received this e-mail in error, please notify me
immediately by reply e-mail and delete the original.<div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Martijn van Oosterhout <kleptog@gmail.com><br>To: Diarmuid Wrenne <dwrenne@yahoo.com><br>Sent: Tuesday, December 11, 2007 12:23:38 PM<br>Subject: Re: [OSM-dev] Populating the database<br><br>
On Dec 11, 2007 12:36 PM, Diarmuid Wrenne <<a rel="nofollow" ymailto="mailto:dwrenne@yahoo.com" target="_blank" href="mailto:dwrenne@yahoo.com">dwrenne@yahoo.com</a>> wrote:<br>> Cheers Martin,<br>><br>> The problem is that postgis support is not being compiled into
Mapnik. scons<br>> is saying pq is not being found. It's installed but not showing up
and I<br>> have tried to add teh path explicitly but still nothing. Very
frustrating.<br><br>You've installed the dev libraries, right? Check for a libpq-fe.h file<br>somewhere under /usr/include.<br><br>Have a nice day,<br>-- <br>Martijn van Oosterhout <<a rel="nofollow" ymailto="mailto:kleptog@gmail.com" target="_blank" href="mailto:kleptog@gmail.com">kleptog@gmail.com</a>> <a rel="nofollow" target="_blank" href="http://svana.org/kleptog/">http://svana.org/kleptog/</a><br></div><br></div></div></div><br>
<hr size=1>Looking for last minute shopping deals? <a href="http://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsearch/category.php?category=shopping">
Find them fast with Yahoo! Search.</a></body></html>