From: | pascal bérest <lists(at)magnetophone(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_restore error |
Date: | 2002-10-10 11:52:36 |
Message-ID: | a05111713b9cb1a7e856d@[80.236.54.8] |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hello everybody,
i am pascal, i am from paris, france, and i am a newbie here.
well, i have a problem with the pg_restore command and i don't find
any informations on the web about it. when trying to restaure a
database, i have the above error :
[postgres(at)preprod2 pgsql]$ bin/pg_restore -d interlig -Fc
/home/postgres/dump_20021010new.out
pg_restore: [archiver (db)] could not execute query: ERROR: Relation
'cable_id_cable_seq' already exists
and i try this :
[postgres(at)preprod2 pgsql]$ bin/pg_restore -d interlig -Fc
/home/postgres/dump_20021010new.out -t synd_article
pg_restore: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit
index 'synd_article_pkey' for table 'synd_article'
pg_restore: [archiver (db)] could not execute query: ERROR: Relation
'synd_article' already exists
I don't understand what can be this error, i just want to restore my
database as the same it was a few hours ago.
thank you for your help,
pascal.
--
From | Date | Subject | |
---|---|---|---|
Next Message | Nigel J. Andrews | 2002-10-10 11:56:27 | Re: Problem running postgre as a windows NT service |
Previous Message | Louis-Marie Croisez | 2002-10-10 11:40:43 | Re: access time performance problem |