Re: pg_restore error

>>> I tried with the -a option, and it was quite the same.
>>> I just tried to delete the synd_article_pkey then restore the table
>>> synd_article, but it didn't recreate the keys as they were. and i
>>> don't know how to do that (as i am using mysql for my other projects
>>> and that it seams to be more simple).
>>>
>>
>> What happened when you tried the -a option?
>
> i have quite the same error. i have a message telling that the key
> can't be duplicate. i suppose that as the id is already existing, it
> can't duplicate it, as in mysql.
>
>> You can create a table with a primary key like so
>>
>> CREATE TABLE test (
>> id int,
>> PRIMARY KEY (id)
>> );
>
> yep, but is a way to create a primary key when the table already exists ?

It seems that your dump file contains data that is already in the database
and so it is complaining when you try to duplicate a primary key

What exactly are you trying to do with your dump and restore?

pg_dump will archive all the data from a table and pg_restore will restore
all the data back into an empty table.

Take a look here for more details

http://www.postgresql.org/idocs/index.php?backup.html

I think the ability to add a primary key after table creation is only
available as of version 7.3 (currently in beta)

HTH

adam