From: | Pedro Salazar <pedro-b-salazar(at)ptinovacao(dot)pt> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | restore a dump file (with postgis tables): errors!! |
Date: | 2003-04-04 09:56:39 |
Message-ID: | 1049450199.10862.55.camel@vitoria.intra.cet.pt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Greetings,
I have a pgsql 7.3 database where I created postgis tables and my schema
with my object model database. I want to dump my database and restore it
in another machine with pgsql (also 7.3.2).
what I did:
1- pg_dump -U postgres locawadb | gzip > locawa1.dmp.gz
2- createdb -U postgres locawadb
(create users in database)
gunzip -c locawa1.dmp.gz | psql -U postgres locawadb
But I got a few errors on the 2 step.
With -a option (echo) in psql I noticed that some errors where about:
- the user owner from my schema could not create a schema (well I
supposed that this operation should be done through super user
postgres);
- that functions like srid() and others did not exist!? (shouldn't
postgres warrant the order of dependences?);
- that some user tables from my schema with geom data types failed to
restore;
- and a few class errors (?) and invalid namespace of my schema!!
My question is: are my procedures of dump and restore database well
done? (I already saw that exist a pg_restore command line, ...is it
equal to the psql command line or it's better?)
thanks,
Pedro Salazar.
--
PS
pedro-b-salazar(at)ptinovacao(dot)pt
PGP:0E129E31D803BC61
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2003-04-04 12:15:08 | Re: Restrict the number of emails to certain keywords with a filter? |
Previous Message | Matt Clark | 2003-04-04 09:27:37 | Re: LVM snapshots |