Re: How to interpret 'depends on' errors in pg_restore? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: How to interpret 'depends on' errors in pg_restore?
Date
Msg-id 97db569f-76e6-4364-8755-c700d014ee97@aklaver.com
Whole thread Raw
In response to Re: How to interpret 'depends on' errors in pg_restore?  (Fire Emerald <fire.github@gmail.com>)
List pgsql-general
On 3/28/24 08:57, Fire Emerald wrote:
> Am 28. März 2024 15:00:06 schrieb Tom Lane <tgl@sss.pgh.pa.us>:
> 
>> Fire Emerald <fire.github@gmail.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.klaver@aklaver.com




pgsql-general by date:

Previous
From: Emond Papegaaij
Date:
Subject: Re: pg_rewind after promote
Next
From: arun chirappurath
Date:
Subject: [MASSMAIL]Table level restore in postgres