MIME-Version: 1.0
References: <CANzqJaD1JNeJfNJkxZOvqSw=ueJLzq3hM3tUf5FJNkbxEr8Z4A@mail.gmail.com>
 <6511b21d495f1c010f05ae9841ee3fdc649dcff2.camel@cybertec.at>
 <CANzqJaB3rHWWHQD2aUqrQvZcdo_doOKTNFcMkBnkvoTt4_JriA@mail.gmail.com> <9dccf4f8-2d45-4e6e-a374-1de66d6cc243@aklaver.com>
In-Reply-To: <9dccf4f8-2d45-4e6e-a374-1de66d6cc243@aklaver.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 13 Feb 2026 11:05:03 -0500
Message-ID: <CANzqJaDbrmgAXmctgFR62o22+CMYnNjmKd06uX9RD3jjUj9u=Q@mail.gmail.com>
Subject: Re: pg_restore failed on foreign key constraint
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003fde3b064ab6c55e"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDbrmgAXmctgFR62o22%2BCMYnNjmKd06uX9RD3jjUj9u%3DQ%40mail.gmail.com>
Precedence: bulk

--0000000000003fde3b064ab6c55e
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Feb 13, 2026 at 10:55=E2=80=AFAM Adrian Klaver <adrian.klaver@aklav=
er.com>
wrote:

> On 2/13/26 06:18, Ron Johnson wrote:
> > On Fri, Feb 13, 2026 at 1:43=E2=80=AFAM Laurenz Albe <laurenz.albe@cybe=
rtec.at
> > <mailto:laurenz.albe@cybertec.at>> wrote:
>
> > Turns out that there's a nightly cron job that dumps this (and other)
> > tables with the "--data-only --disable-triggers" options and then does
> > "psql -Xaf mumble.sql" to load them into this database.
> >
> > But access_email_id=3D2073 is in the source access_email, so I've got t=
o
> > figure out why it's not being loaded into the target.
>
> Is it in the dump file from the source?
>

Some tables aren't being dumped at the source;  Thus, the missing records.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--0000000000003fde3b064ab6c55e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Feb 13, 2026 at 10:55=E2=80=AFAM =
Adrian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klave=
r@aklaver.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_con=
tainer"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex=
;border-left:1px solid rgb(204,204,204);padding-left:1ex">On 2/13/26 06:18,=
 Ron Johnson wrote:<br>
&gt; On Fri, Feb 13, 2026 at 1:43=E2=80=AFAM Laurenz Albe &lt;<a href=3D"ma=
ilto:laurenz.albe@cybertec.at" target=3D"_blank">laurenz.albe@cybertec.at</=
a> <br>
&gt; &lt;mailto:<a href=3D"mailto:laurenz.albe@cybertec.at" target=3D"_blan=
k">laurenz.albe@cybertec.at</a>&gt;&gt; wrote:<br>
<br>
&gt; Turns out that there&#39;s a nightly=C2=A0cron job that dumps this (an=
d other) <br>
&gt; tables with the &quot;--data-only --disable-triggers&quot; options and=
 then does <br>
&gt; &quot;psql -Xaf mumble.sql&quot; to load them into this database.<br>
&gt; <br>
&gt; But access_email_id=3D2073 is in the source access_email, so I&#39;ve =
got to <br>
&gt; figure out why it&#39;s not being loaded into the target.<br>
<br>
Is it in the dump file from the source?<br></blockquote><div></div></div><d=
iv><br></div><div>Some tables aren&#39;t being dumped at the source;=C2=A0 =
Thus, the missing records.</div><div><br></div><span class=3D"gmail_signatu=
re_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div di=
r=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil m=
e, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div><=
/div></div></div></div>

--0000000000003fde3b064ab6c55e--