Re: pg_dumpall and restore - Mailing list pgsql-sql

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