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

Ethan Alpert ealpert at digitalglobe.com
Tue Dec 14 11:13:16 PST 2004


Hey now...that's sweet! Now do you have a select that will filter out all the postgis functions when you dump the schema?

-e

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of TECHER Jean David
Sent: Tuesday, December 14, 2004 7:48 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] pg-dump from postgis 0.8 to 0.9.1


One way

In a SQL file (example toto.sql), writes this

select 'pg_dump -c -O -t ' || tablename || '  your_database >> dump .sql ' from pg_tables  where  (tablename not like 'pg_%') and (tablename not like 'sql_%') (tablename not like 'spatial_ref_sys_%')

then do

psql -d your_database -f toto.sql  > dump.sh

dropdb your_database
createdb your_database
createlang plpgsql your_database
psql -d your_database  -f postgis.sql
./dump.sh
----------------------------------------------------------------
TECHER Jean David
Responsable Informatique 01MAP
e-mail: davidtecher at yahoo.fr
site perso : http://techer.pascal.free.fr/postgis/
site pro: http://www.01map.com/download/
K-S:"The greatest trick the devil pulled off was convincing people he didn't exist"
------------------------------------------------------------
----- Original Message -----
From: "Guillaume SUEUR (Géosignal)" <guillaume.sueur at geosignal.fr>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Tuesday, December 14, 2004 3:37 PM
Subject: Re: [postgis-users] pg-dump from postgis 0.8 to 0.9.1


> -t pour la table, -d pour les inserts
>
>
> TECHER Jean David wrote:
> > ***********************
> > Your mail has been scanned by InterScan VirusWall.
> > ***********-***********
> >
> >
> > what are options you use with pg_dump???
> > ----------------------------------------------------------------
> > TECHER Jean David
> > Responsable Informatique 01MAP
> > e-mail: davidtecher at yahoo.fr
> > site perso : http://techer.pascal.free.fr/postgis/
> > site pro: http://www.01map.com/download/
> > K-S:"The greatest trick the devil pulled off was convincing people 
> > he
didn't
> > exist"
> > ------------------------------------------------------------
> > ----- Original Message -----
> > From: "Guillaume SUEUR (Géosignal)" <guillaume.sueur at geosignal.fr>
> > To: "PostGIS Users Discussion" 
> > <postgis-users at postgis.refractions.net>
> > Sent: Tuesday, December 14, 2004 3:29 PM
> > Subject: [postgis-users] pg-dump from postgis 0.8 to 0.9.1
> >
> >
> >
> >>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 ?
> >>
> >>Thanks
> >>--
> >>---------------------------
> >>Guillaume SUEUR
> >>GEOSIGNAL - Groupe BVA
> >>25bis Avenue Marcel Dassault
> >>31505 TOULOUSE CEDEX 5
> >>----------------------------
> >>
> >>_______________________________________________
> >>postgis-users mailing list postgis-users at postgis.refractions.net
> >>http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> >
> >
>
> --
> ---------------------------
> Guillaume SUEUR
> GEOSIGNAL - Groupe BVA
> 25bis Avenue Marcel Dassault
> 31505 TOULOUSE CEDEX 5
> ----------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list