Received: from malur.postgresql.org ([2a02:16a8:dc51::56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-novice-owner+archive@lists.postgresql.org>)
	id 1g9wnr-0006C4-9H
	for pgsql-novice@arkaria.postgresql.org; Tue, 09 Oct 2018 18:32:19 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-novice-owner+archive@lists.postgresql.org>)
	id 1g9wnp-00031r-FT
	for pgsql-novice@arkaria.postgresql.org; Tue, 09 Oct 2018 18:32:17 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1g9wnp-00031g-93; Tue, 09 Oct 2018 18:32:17 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1g9wnn-0002MQ-6L; Tue, 09 Oct 2018 18:32:16 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id w99IW23Q019951;
	Tue, 9 Oct 2018 14:32:02 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Laurenz Albe <laurenz.albe@cybertec.at>
cc: "Rossi, Maria" <maria.rossi@jackson.com>,
        "'pgsql-sql@lists.postgresql.org'" <pgsql-sql@lists.postgresql.org>,
        "'pgsql-novice@lists.postgresql.org'"
 <pgsql-novice@lists.postgresql.org>
Subject: Re: pg_dumpall and restore
In-reply-to: <47175ca8aea768568fb51e1a91c94d436ef79d97.camel@cybertec.at>
References: 
 <323742d3468543f590fc081c7fba0c7a@DC03PXMBP003.jacksonnational.com>
 <47175ca8aea768568fb51e1a91c94d436ef79d97.camel@cybertec.at>
Comments: In-reply-to Laurenz Albe <laurenz.albe@cybertec.at>
	message dated "Tue, 09 Oct 2018 20:28:25 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <19949.1539109922.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Tue, 09 Oct 2018 14:32:02 -0400
Message-ID: <19950.1539109922@sss.pgh.pa.us>
List-Id: <pgsql-novice.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-novice@lists.postgresql.org>
List-Owner: <mailto:pgsql-novice-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-novice>
Precedence: bulk

Laurenz Albe <laurenz.albe@cybertec.at> writes:
> Rossi, Maria wrote:
>> Has anyone encountered  having dups rows  loaded?  Any idea  what cause=
d 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