How to interpret 'depends on' errors in pg_restore?

From: Fire Emerald <fire(dot)github(at)gmail(dot)com>
To: <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: How to interpret 'depends on' errors in pg_restore?
Date: 2024-03-28 09:32:26
Message-ID: 18e84674c10.2815.a5aef60df33e8d2ac3d54c6545825f63@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message 김명준 2024-03-28 11:56:59 Inquiry on Participating in the Korean Translation Project for PostgreSQL Documentation
Previous Message Adrian Klaver 2024-03-28 02:37:03 Re: After 10 -> 15 upgrade getting "cannot commit while a portal is pinned" on one python function