[postgis-users] Setup problems: "cache lookup failed"

[Toby White]

I'm trying to get going with postgis. I installed it fine using fink  
on my Mac OS X laptop; I'm now trying to install it on a Linux server.

This is using ubuntu 8.04, which has the following packages:

* postgresql 8.3
* postgis 1.3.3
* proj 4.6
* gdal 1.4
* geos 2.2.3

all install fine, but when preparing a template postgis database using  
lwconfig.sql, I get the following:



postgres at domU-12-31-39-00-88-36:~$ psql -d template_postgis -f /usr/ 
share/postgresql-8.3-postgis/lwpostgis.sql
BEGIN
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:44: NOTICE:  type  
"histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
CREATE FUNCTION
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:50: ERROR:  cache  
lookup failed for type 16769
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:56: ERROR:   
current transaction is aborted, commands ignored until end of  
transaction block



the last line being repeated about 1000 times, for each SQL command in  
the file.

If I upgrade to geos 3.0.0, the script gets slightly further, but then  
fails with almost the same error message:



postgres at domU-12-31-39-00-88-36:~$ psql -d template_postgis -f /usr/ 
share/postgresql-8.3-postgis/lwpostgis.sql
BEGIN
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:44: NOTICE:  type  
"histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
CREATE FUNCTION
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:50: NOTICE:   
return type histogram2d is only a shell
CREATE FUNCTION
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:56: NOTICE:   
argument type histogram2d is only a shell
CREATE FUNCTION
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:62: NOTICE:   
argument type histogram2d is only a shell
CREATE FUNCTION
CREATE TYPE
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:88: NOTICE:  type  
"spheroid" is not yet defined
DETAIL:  Creating a shell type definition.
CREATE FUNCTION
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:94: ERROR:  cache  
lookup failed for type 16781
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:100: ERROR:   
current transaction is aborted, commands ignored until end of  
transaction block


Any ideas what's going wrong, or how it could be fixed?

Toby