Re: pg_dumpall and restore - Mailing list pgsql-sql

From Tom Lane
Subject Re: pg_dumpall and restore
Date
Msg-id 19950.1539109922@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dumpall and restore  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-sql
Laurenz Albe <laurenz.albe@cybertec.at> writes:
> Rossi, Maria wrote:
>> Has anyone encountered  having dups rows  loaded?  Any idea  what caused this and how to prevent?

> I don't believe that pg_dumpall miraculously duplicated the row.

What seems much more likely is that the dump script was loaded twice.
The script expects to be fed into an empty database ...

            regards, tom lane


pgsql-sql by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: pg_dumpall and restore
Next
From: Christopher McDonald
Date:
Subject: remove from list?