Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sLIm7-00EILQ-Vc for pgsql-general@arkaria.postgresql.org; Sun, 23 Jun 2024 08:40:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sLIm5-007RgV-W5 for pgsql-general@arkaria.postgresql.org; Sun, 23 Jun 2024 08:40:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sLIm5-007RgN-Is for pgsql-general@lists.postgresql.org; Sun, 23 Jun 2024 08:40:37 +0000 Received: from mail-vk1-xa35.google.com ([2607:f8b0:4864:20::a35]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sLIlz-003754-J3 for pgsql-general@lists.postgresql.org; Sun, 23 Jun 2024 08:40:37 +0000 Received: by mail-vk1-xa35.google.com with SMTP id 71dfb90a1353d-4ef6b14a34eso216778e0c.1 for ; Sun, 23 Jun 2024 01:40:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1719132030; x=1719736830; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=a+G4zU5arNqZbpDChJ0I1oeHFBLoEVdis6z1e4nesfo=; b=cU5HOrNgXSr4upKFtAL4l3C31YmardYJhycQANTp6tfFTD+CNpFxUZnErqoSdL6i7r 5BnTvIjt9IeGBCdUFPrabDq3o9iwLLZh9MGplnj/XKqX0NBBnkEh+YGTWSjaOYSpOBw6 I4G77o+ofjfqDkvYzCMgvKFCIXniondpNQYXEI7gq5hkLmzvznN5qG0fAsIHu/cB0KF0 zQIU+ARN4C9Ed04atK4214WAygDmCb8Jz4Kk0uvupBkftt7qgTKRHgSGyr8/bDjR6/tW WHNLM3PoagkYr4wzQEC2xwRKZlUEIl+m4RJYeEoNYUhujFRVFWiPYLpy8/eX0OmiXpoU Mjcw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1719132030; x=1719736830; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=a+G4zU5arNqZbpDChJ0I1oeHFBLoEVdis6z1e4nesfo=; b=drNsFg7exqOPvVs9JCN2jFJfYHa4j+8maeSLxi51JxoAz79Z8E4z4Wk3Lk1eDFHAuh R9FB8dzYykl52bI+FhEUfe7QWztnlzl904AtxQg3lEWrcIPOs4TBegysbfhtCoPPyQ+J LJiHNLkgSHM74099FmOylFCXLi+eW4BWvZknHBicAV1wH6ZKbXU6JBIa/ugCfWgU/kVJ WMGpV4TQaCkxpzj09q7uSTpy+zSIJYBrV0hsAgk8NqiqLw+L/drZhTgpPoMeYhJlHCIp hOE3ws6JYrrtNgpdXsoJyBieE3WxcBpxiecd7iUpb08wntMGpIbKQWSFTON4TZcedGhH MBIA== X-Gm-Message-State: AOJu0Ywj2fpW0ZRxTodBYoLZ/jzUaFJtH/xkzNtmLkwoRr36vq7zg9LI +e72vulHVTiKwe1G8CRb6odegCFiSD3XbRsz72x+9kquCDH/NuKM5oD0sPrVYhldJl7agZjFnOR U6RbLRupZ18uMPWXc5epTgmft5d880Php X-Google-Smtp-Source: AGHT+IHgqRQ6o7lHpNIgc25k+n8+QiHxj14RhuUfK5UqsyjRRaVRbDVPxIt8Spj6fUxrDsEt7weVMIEdzSxyBoGjD68= X-Received: by 2002:a05:6122:202a:b0:4ef:5e3f:599a with SMTP id 71dfb90a1353d-4ef6d8baf8emr940636e0c.14.1719132029659; Sun, 23 Jun 2024 01:40:29 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Shaheed Haque Date: Sun, 23 Jun 2024 09:40:18 +0100 Message-ID: Subject: Re: pg_dump restores as expected on some machines and reports duplicate keys on others To: pgsql-general list Content-Type: multipart/alternative; boundary="000000000000f33154061b8a9dd3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f33154061b8a9dd3 Content-Type: text/plain; charset="UTF-8" First, thanks for all the kind replies. To my eternal shame, after spending hours trying to debug this, I found, buried deep in one of my own initialisation scripts, the creation of a handful of "seed" database objects which, of course, caused all my woes. Thanks again, Shaheed --000000000000f33154061b8a9dd3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
First, thanks for all the kind replies.
To my eternal shame, after spending hours trying to debug this,= I found, buried deep in one of my own initialisation scripts, the creation= of a handful of "seed" database objects which, of course, caused= all my woes.

Thanks again,

Shaheed

--000000000000f33154061b8a9dd3--