[postgis-users] pg-dump from postgis 0.8 to 0.9.1

[strk at refractions.net]

On Tue, Dec 14, 2004 at 03:29:01PM +0100, "Guillaume SUEUR (Géosignal)" wrote:
> Hi,
> 
> I've dumped my database to load it into a new one with postgis 0.9.1.
> On the psql -d database -f dumpFile.sql, for all spatial table i've got 
> a 'couldn't parse objetcs in geometry'
> 
> Any idea ?

Try something like this:

postgis-0.9.1$ pg_dump -Fc MYDB_08 > MYDB_08.DUMP
postgis-0.9.1$ utils/postgis_restore.pl postgis.sql MYDB_09 MYDB_08.DUMP \
	> /tmp/log 2>&1
postgis-0.9.1$ grep KEEPING /tmp/log

Last lineshould show very few KEEPING lines if any, and each of
them should be NOT a postgis object.

--strk;