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

[strk at refractions.net]

On Tue, Dec 14, 2004 at 12:13:16PM -0700, Ethan Alpert wrote:
> 
> 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

functions, types, operators, operator classes, aggregates.
The more people test it the more we'll get it stable.
--strk;

> 
> -----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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users