Re: How to interpret 'depends on' errors in pg_restore?

On 3/28/24 08:57, Fire Emerald wrote:
> Am 28. März 2024 15:00:06 schrieb Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>
>> Fire Emerald <fire(dot)github(at)gmail(dot)com> 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.

Look in the Postgres log to see if there is more information.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com