[ gpsdrive ] postgresql & postgis integration

[Chris H]

On Friday 06 June 2008 00:50:26 info at 4x4falcon.com wrote:

> Firstly is it a clean install of Ubuntu.  If you've had the problems
> before it may well be something to do with the actual os installation
> rather than postgresql/postgis.

As said, your instructions are fine and nothing wrong with the install or OS. 
Me thinks the log file has some answers but this is currently above me.

2008-06-05 23:33:20 EDT STATEMENT:  CREATE ROLE chris123 NOSUPERUSER CREATEDB 
NOCREATEROLE INHERIT LOGIN;
2008-06-05 23:34:18 EDT NOTICE:  type "histogram2d" is not yet defined
2008-06-05 23:34:18 EDT DETAIL:  Creating a shell type definition.
2008-06-05 23:34:19 EDT ERROR:  could not load 
library "/usr/lib/postgresql/8.3/lib/liblwgeom.so": /usr/lib/postgresql/8.3/lib/liblwgeom.so: 
undefined symbol: pj_get_release
2008-06-05 23:34:19 EDT STATEMENT:  CREATE OR REPLACE FUNCTION 
histogram2d_in(cstring)
                RETURNS histogram2d
                AS '/usr/lib/postgresql/8.3/lib/liblwgeom', 'lwhistogram2d_in'
                LANGUAGE 'C' IMMUTABLE STRICT;
2008-06-05 23:34:19 EDT ERROR:  current transaction is aborted, commands 
ignored until end of transaction block
2008-06-05 23:34:19 EDT STATEMENT:  CREATE OR REPLACE FUNCTION 
ST_histogram2d_in(cstring)
                RETURNS histogram2d
                AS '/usr/lib/postgresql/8.3/lib/liblwgeom', 'lwhistogram2d_in'
                LANGUAGE 'C' IMMUTABLE STRICT;
2008-06-05 23:34:19 EDT ERROR:  current transaction is aborted, commands 
ignored until end of transaction block
-----------------------------------eof---------------

So its an issue wrt "histogram2d" (no clue what this is) as its not defined. 
Then it cant load a specific library, "liblwgeom.so"  and gets an undefined 
symbol pj_get_release. Ive seen this error before somewhere (mapserver I 
think) and it may be related to the version of proj installed. 

I have 4.6.0-1 installed according to synaptic.

What version are you running. 

-- 
/ch