Hi Andy,
First of all, thank you very much for your advices,
2009/8/26 Andy Shellam
> Hi Pablo
>
> - As regards the duplicated rows, no, I don't get duplicated rows in all
>> the tables stored in the database because
>> some tables have primary-keys (and/or UNIQUE) constraints. These
>> constr
indows xp.
Thanks a lot for your advices,
Regards, Pablo
2009/8/24 Tom Lane
> Pablo Alonso-Villaverde Roza writes:
> > I'm getting duplicated rows in some of my tables when I try to restore
> data
> > from a dump file generated with 'pg_dumpall'.
>
>
Hi all,
I'm getting duplicated rows in some of my tables when I try to restore data
from a dump file generated with 'pg_dumpall'.
I use:
pg_dumpall -c -U postgres > mybackup.sql
to dump all the data, roles, etc. into a file.
Then I try to restore the data using:
psql -U postgres -f mybackup
