[OSM-dev] Populating Mapnik compile issues with libpq

Diarmuid Wrenne dwrenne at yahoo.com
Tue Dec 11 14:36:14 GMT 2007 

Thanks Martin

Based on what you said I copied the contents of the /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. 

Since i am on Ubuntu I modified the osm.xml with
  <Layer name="text" status="on" srs="+proj=merc +datum=WGS84  +k=1.0 +units=m +over +no_defs">
    <StyleName>text</StyleName>
    <Datasource>
      <Parameter name="type">postgis</Parameter>
      <Parameter name="host">/var/run/postgresql</Parameter>
      <Parameter name="port">5432</Parameter>     
      <Parameter name="user">gis</Parameter>
      <Parameter name="dbname">gis</Parameter>
      <Parameter name="table">planet_osm_point</Parameter>
      <Parameter name="estimate_extent">true</Parameter>
    </Datasource>
  </Layer>

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. 

http://www.lukulu.com/map/tilesv3.htm .  Just Paris, France for now.

Thanks allot for all your help.

Diarmuid

Here is a list of all the libpq* on my machine
/usr/include/postgresql/internal/libpq
/usr/include/postgresql/internal/libpq-int.h
/usr/include/postgresql/libpq-fe.h
/usr/include/postgresql/libpq
/usr/include/postgresql/libpq/libpq-fs.h
/usr/lib/libpq.a
/usr/lib/libpq.so.3
/usr/lib/libpq.so.4
/usr/lib/libpq.so
/usr/lib/libpq.so.3.1
/usr/lib/libpq.so.4.1
/usr/lib/libpq-fe.h
/usr/lib/internal/libpq
/usr/lib/internal/libpq-int.h
/usr/lib/libpq
/usr/lib/libpq/libpq-fs.h
/usr/share/doc/libpq-dev
/usr/share/doc/libpq3
/usr/share/doc/libpq4
/usr/share/doc/postgresql-doc-8.1/html/libpq.html
/usr/share/doc/postgresql-doc-8.1/html/libpq-async.html
/usr/share/doc/postgresql-doc-8.1/html/libpq-build.html
/usr/share/doc/postgresql-doc-8.1/html/libpq-cancel.html
/usr/share/doc/postgresql-doc-8.1/html/libpq-control.html
/usr/share/doc/postgresql-doc-8.1/html/libpq-copy.html
/usr/share/doc/postgresql-doc-8.1/html/libpq-envars.html
/usr/share/doc/postgresql-doc-8.1/html/libpq-example.html
/usr/share/doc/postgresql-doc-8.1/html/libpq-exec.html
/usr/share/doc/postgresql-doc-8.1/html/libpq-fastpath.html
/usr/share/doc/postgresql-doc-8.1/html/libpq-notice-processing.html
/usr/share/doc/postgresql-doc-8.1/html/libpq-notify.html
/usr/share/doc/postgresql-doc-8.1/html/libpq-pgpass.html
/usr/share/doc/postgresql-doc-8.1/html/libpq-pgservice.html
/usr/share/doc/postgresql-doc-8.1/html/libpq-ssl.html
/usr/share/doc/postgresql-doc-8.1/html/libpq-status.html
/usr/share/doc/postgresql-doc-8.1/html/libpq-threading.html
/usr/share/locale/cs/LC_MESSAGES/libpq3.mo
/usr/share/locale/de/LC_MESSAGES/libpq3.mo
/usr/share/locale/es/LC_MESSAGES/libpq3.mo
/usr/share/locale/fr/LC_MESSAGES/libpq3.mo
/usr/share/locale/hr/LC_MESSAGES/libpq3.mo
/usr/share/locale/it/LC_MESSAGES/libpq3.mo
/usr/share/locale/nb/LC_MESSAGES/libpq3.mo
/usr/share/locale/pt_BR/LC_MESSAGES/libpq3.mo
/usr/share/locale/ru/LC_MESSAGES/libpq3.mo
/usr/share/locale/sl/LC_MESSAGES/libpq3.mo
/usr/share/locale/sv/LC_MESSAGES/libpq3.mo
/usr/share/locale/tr/LC_MESSAGES/libpq3.mo
/usr/share/locale/zh_CN/LC_MESSAGES/libpq3.mo
/usr/share/locale/zh_TW/LC_MESSAGES/libpq3.mo
/var/cache/apt/archives/libpq-dev_8.1.10-0ubuntu0.6.06.1_i386.deb
/var/cache/apt/archives/libpq3_1%3a7.4.12-3_i386.deb
/var/cache/apt/archives/libpq4_8.1.10-0ubuntu0.6.06.1_i386.deb
/var/lib/dpkg/info/libpq-dev.md5sums
/var/lib/dpkg/info/libpq-dev.list
/var/lib/dpkg/info/libpq3.list
/var/lib/dpkg/info/libpq3.md5sums
/var/lib/dpkg/info/libpq3.postinst
/var/lib/dpkg/info/libpq3.postrm
/var/lib/dpkg/info/libpq3.shlibs
/var/lib/dpkg/info/libpq4.list
/var/lib/dpkg/info/libpq4.md5sums
/var/lib/dpkg/info/libpq4.postinst
/var/lib/dpkg/info/libpq4.postrm
/var/lib/dpkg/info/libpq4.shlibs

 
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.

----- Original Message ----
From: Martijn van Oosterhout <kleptog at gmail.com>
To: Diarmuid Wrenne <dwrenne at yahoo.com>
Sent: Tuesday, December 11, 2007 12:23:38 PM
Subject: Re: [OSM-dev] Populating the database


On Dec 11, 2007 12:36 PM, Diarmuid Wrenne <dwrenne at yahoo.com> wrote:
> Cheers Martin,
>
> The problem is that postgis support is not being compiled into
 Mapnik. scons
> is saying pq is not being found. It's installed but not showing up
 and I
> have tried to add teh path explicitly but still nothing. Very
 frustrating.

You've installed the dev libraries, right? Check for a libpq-fe.h file
somewhere under /usr/include.

Have a nice day,
-- 
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/







      ____________________________________________________________________________________
Looking for last minute shopping deals?  
Find them fast with Yahoo! Search.  http://tools.search.yahoo.com/newsearch/category.php?category=shopping
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20071211/e30a6c57/attachment.html>

More information about the dev mailing list