public inbox for [email protected]
help / color / mirror / Atom feedFrom: Fire Emerald <[email protected]>
To: Tom Lane <[email protected]>
Cc: [email protected]
Subject: Re: How to interpret 'depends on' errors in pg_restore?
Date: Thu, 28 Mar 2024 16:57:04 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
Am 28. März 2024 15:00:06 schrieb Tom Lane <[email protected]>:
> Fire Emerald <[email protected]> writes:
>> 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 ...
>
> That is not an error, it's just verbose display of one of the items
> in the dump.
Well, I know it's not an error, but it's everything i got. There was no
error shown. The command completed, but without anything imported.
>
>> Nothing was restored.
>
> You would need to show us the actual errors. (Suggestion:
> leave off --verbose, it's just clutter.) A guess though is
> that the import failed because of foreign key constraints.
> --data-only mode is not good at ordering the table loads to
> ensure that FK constraints are satisfied on-the-fly.
>
> regards, tom lane
As i said, the same import but with INSERT INTOs worked without any issues.
So no, there are no FK constraints failing.
But the target and source table had partitioned tables attached, using
ATTACH PARTITION.
The schema was like:
db1 schema1 public table1 (links to the listed below)
db1 schema1 subpartitions backends_y2024w03
db1 schema1 subpartitions backends_y2024w04
db1 schema1 subpartitions backends_y2024w05
The partitioning must be the problem somehow.
view thread (6+ messages) latest in thread
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], [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