Fischer Ulrich <[EMAIL PROTECTED]> 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.
> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
