[ gpsdrive ] postgresql & postgis integration

[info at 4x4falcon.com]

> 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',

Does the file "/usr/lib/postgresql/8.3/lib/liblwgeom.so" actually exist
and are the permissions correct?   Mine is a symlink to
"/usr/lib/postgresql/8.3/lib/liblwgeom.so.1.3" whose permissions are 644


> 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.

Same.

And you are running this as user postgres?

Regards
Ross