From: Fire Emerald <fire.github@gmail.com>
To: <pgsql-general@lists.postgresql.org>
Date: Thu, 28 Mar 2024 10:32:26 +0100
Message-ID: <18e84674c10.2815.a5aef60df33e8d2ac3d54c6545825f63@gmail.com>
User-Agent: AquaMail/1.50.0 (build: 105000429)
Subject: How to interpret 'depends on' errors in pg_restore?
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="18e84674ef56a2e281527a6146"
Archived-At: <https://www.postgresql.org/message-id/18e84674c10.2815.a5aef60df33e8d2ac3d54c6545825f63%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--18e84674ef56a2e281527a6146
Content-Type: text/plain; format=flowed; charset="us-ascii"
Content-Transfer-Encoding: 8bit

Hello everyone,

I created a database dump in postgres 'custom' format using: pg_dump -d 
origin --data-only -Fc > file.dump

Then i did a pg_restore -d target --verbose -Fc file.dump and saw in the 
output this:

5145 0 730750 TABLE subpartitions backends_y2024w03 userA
;        depends on: 237
.... and so on ...

Nothing was restored. The tables mentioned in the output do all exist - but 
in a different database, thus the "internal id's" - perhaps thats what 
"depends on" refers to - are in fact different but the id's should not 
matter, as the table names are important and they all exist.

How to interpret the "depends on" errors which lead to nothing beeing 
imported? and is there a way to tell pg_restore to skip those depends on 
checks?

When i created a sql dump with inserts, everything worked but these dumps 
are not that efficient.

Best regards,
Christian

--18e84674ef56a2e281527a6146
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.=
w3.org/TR/html4/loose.dtd">
<html>
<body>
<div dir=3D"auto">
Hello everyone,<div dir=3D"auto"><br></div><div dir=3D"auto">I created a da=
tabase dump in postgres 'custom' format using: pg_dump -d origin --data-onl=
y -Fc &gt; file.dump</div><div dir=3D"auto"><br></div><div dir=3D"auto">The=
n i did a pg_restore -d target --verbose -Fc file.dump and saw in the outpu=
t this:</div><div dir=3D"auto"><br></div><div dir=3D"auto">5145 0 730750 TA=
BLE subpartitions backends_y2024w03 userA</div><div dir=3D"auto">;&nbsp; &n=
bsp; &nbsp; &nbsp; depends on: 237</div><div dir=3D"auto">.... and so on ..=
.</div><div dir=3D"auto"><br></div><div dir=3D"auto">Nothing was restored. =
The tables mentioned in the output do all exist - but in a different databa=
se, thus the "internal id's" - perhaps thats what "depends on" refers to - =
are in fact different <b>but </b>the id's should not matter, as the table n=
ames are important and they all exist.</div><div dir=3D"auto"><br></div><di=
v dir=3D"auto">How to interpret the "depends on" errors which lead to nothi=
ng beeing imported? and is there a way to tell pg_restore to skip those dep=
ends on checks?</div><div dir=3D"auto"><br></div><div dir=3D"auto">When i c=
reated a sql dump with inserts, everything worked but these dumps are not t=
hat efficient.</div><div dir=3D"auto"><br></div><div dir=3D"auto">Best rega=
rds,</div><div dir=3D"auto">Christian</div>
</div></body>
</html>

--18e84674ef56a2e281527a6146--