[postgis-users] postgis database restore problem

[strk at refractions.net]

You can't restore postgis databases w/out special care
when dumping. See the "Hard upgrade" section in postgis
manual.

--strk;

On Sun, Jun 25, 2006 at 12:08:20PM -0500, Don wrote:
> I am trying to restore a postgis database which was vreated using the
> pg_dumpall command.
> I get the following messages:
> 
> psql:dbsave2:3523: ERROR:  could not find function
> "GEOS_polygonize_garray" in f
> ile "/usr/lib/postgresql/liblwgeom.so.1.1"
> ALTER FUNCTION public.polygonize_garray(geometry[]) OWNER TO drh;
> psql:dbsave2:3526: ERROR:  function public.polygonize_garray(geometry[])
> does no
> t exist
> 
> CREATE FUNCTION translate(geometry, double precision, double precision,
> double p
> recision) RETURNS geometry
>     AS '$libdir/liblwgeom.so.1.1', 'LWGEOM_translate'
>     LANGUAGE c IMMUTABLE STRICT;
> 
> psql:dbsave2:4125: ERROR:  could not find function "LWGEOM_translate" in
> file "/
> usr/lib/postgresql/liblwgeom.so.1.1"
> ALTER FUNCTION public.translate(geometry, double precision, double
> precision, do
> uble precision) OWNER TO drh;
> psql:dbsave2:4128: ERROR:  function public.translate(geometry, double
> precision,
>  double precision, double precision) does not exist
> 
> 
> CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
>     AS '/usr/local/pgsql/lib/plpgsql', 'plpgsql_call_handler'
>     LANGUAGE c;
> psql:dbsave2:33983: ERROR:  could not access file
> "/usr/local/pgsql/lib/plpgsql"
> : No such file or directory
> I searched the geos source code and could not find the polygonize
> function.  I found some bug reports on it.  It seems to have disappeared
> and replaced.  I was wondering how to code a replacement statement.
> I cannot fine a plpgsql file,but I found a plpgsq.so file.
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 

 /"\    ASCII Ribbon Campaign
 \ /    Respect for low technology.
  X     Keep e-mail messages readable by any computer system.
 / \    Keep it ASCII.