Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Restoring a Databases that features tserach2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fischer Ulrich <ulrich(dot)fischer(at)aerodynamics(dot)ch>
Cc: a(dot)schmitz(at)cityweb(dot)de, pgsql-admin(at)postgresql(dot)org,pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Restoring a Databases that features tserach2
Date: 2004-04-22 13:47:47
Message-ID: 25783.1082641667@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
Fischer Ulrich <ulrich(dot)fischer(at)aerodynamics(dot)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.

> 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

In response to

Responses

pgsql-admin by date

Next:From: Fischer UlrichDate: 2004-04-22 13:56:40
Subject: Re: [GENERAL] Restoring a Databases that features tserach2
Previous:From: Oleg BartunovDate: 2004-04-22 13:33:55
Subject: Re: [GENERAL] Restoring a Databases that features tserach2

pgsql-general by date

Next:From: Fischer UlrichDate: 2004-04-22 13:56:40
Subject: Re: [GENERAL] Restoring a Databases that features tserach2
Previous:From: John Sidney-WoollettDate: 2004-04-22 13:44:40
Subject: Re: Unicode + LC_COLLATE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group