public inbox for [email protected]  

help / color / mirror / Atom feed

From: Fire Emerald <[email protected]>
To: [email protected]
Subject: How to interpret 'depends on' errors in pg_restore?
Date: Thu, 28 Mar 2024 10:32:26 +0100
Message-ID: <[email protected]> (raw)

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: How to interpret 'depends on' errors in pg_restore?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox