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
