Re: pg_dumpall and restore
Keith <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.novice,gmane.comp.db.postgresql.sql |
|---|---|
| Message-ID | <CAHw75vv6ODFZBTN-n+jBVUfGGv_VYxhxN3p3FTV5fNhdtr9E0g@mail.gmail.com> |
On Tue, Oct 9, 2018 at 1:19 PM Rossi, Maria <[email protected]> wrote: > Hi, > > > > I upgraded our postgres database from V9.3 to V10.5. Used pg_dumpall > then restore it to the new instance. > > After the restore, we notice that 1 table had duplicate rows, such that it > was not able to create the primary key. > > I checked the old database, it does not have the dups. > > Has anyone encountered having dups rows loaded? Any idea what caused > this and how to prevent? > > > > Your help would be much appreciated. > > > > Thanks. > > Maria > > > > > > > Did you use the pg_dumpall binary from 10.5 to create the dump? Keith