Fischer Ulrich <ulrich.fischer@aerodynamics.ch> writes:
pg_dump (PostgreSQL) 7.3.2
(pg_dumpall -g GLOBALobjects.sql) pg_dump -s DATABASE > DBschema.sql pg_dump -Fc DATABASE > DBdata.tar
and rebuilt on the new system with:
psql (PostgreSQL) 7.4.1 1. createdb DATABASE 2. (psql DATABASE < GLOBALobjects.sql) 3. psql DATABASE < tsearch2.sql 3.a. psql DATABASE < setup_ge_ispell.sql 4. psql DATABASE < DBschema.sql 5. pg_restore -N -a -v -d DATABASE DBdata.tar
This is certainly not going to work because the dump from the old database will already have all the tsearch2 objects, not to mention whatever setup_ge_ispell.sql may create. You should get rid of steps 3 and 3a.
Get rid of Step 3 and 3a produces Errors in Step 4 like:
: CREATE TABLE REVOKE GRANT CREATE TABLE REVOKE GRANT ERROR: type "tsvector" does not exist ERROR: relation "mitarbeiter" does not exist :
So I think this is not a good idea ;-) I've got now a Sollution which I'll post after writing and testing my own HowTo!
regards
Ulrich
There is no difference when dumped with "pg_dump (PostgreSQL) 7.4.1". I get the same error. When I do not update the dict-settings (setup_ge_ispell.sql) I can not even restore the other datas.
If you're still having trouble, try dropping the -N option to pg_restore. I don't know why that option even exists ... there is no practical use to it AFAIK.
regards, tom lane
-- Ulrich G. Fischer Dipl. Natw. ETH Center Aerodynamics Ruag Aerospace P.O. Box 301 CH-6032 Emmen Tel. +41 41 268 23 53 Fax. +41 41 268 38 97 ulrich.fischer@aerodynamics.ch www.ruag.com
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
