Re: pg_restore error

Are you sure the synd_article table and cable_id_cable_seq sequence aren't
already in the database?

Presumably your dump file contains the create statements for these two
objects and so the pg_restore is trying to create them.

How did you create the dump file? The -a switch will allow you to dump only
the data if that¹s what you need. Looks like you may be dumping the schema
as well

HTH

adam

> 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@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@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.