Re: Postgres 9.6 to 12.7 pg_upgrade error - terminating connection due to administrator command

Thanks for your response, David.

I realized I was running multiple threads to ("-j 12") run the pg_upgrade.
If one thread fails, it sends a kill to other threads. Hence the fatal
error.

However, running it as a single thread always fails at the below step:

[image: Screen Shot 2021-08-02 at 11.38.20 AM.png]

The dump file has something like this:

[image: Screen Shot 2021-08-02 at 11.40.01 AM.png]
Multiple "Create sequence" and "Drop sequence". However the drop sequence
doesn't seem to drop the sequence cleanly hence failing the restore process.

Are you or anyone aware of this issue while running pg_upgrade from 9.6 to
12.7?

On Fri, 30 Jul 2021 at 23:07, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> On Friday, July 30, 2021, Dhanush D <dhanushdk94(at)gmail(dot)com> wrote:
>>
>>
>> pg_restore: error: could not execute query: FATAL: terminating connection due to administrator command
>>
>>
> Did you control-C or something, maybe remote connection dropped?
>
>
>
>> pg_restore: creating SEQUENCE "schema99.sequence2"
>> pg_restore: creating SEQUENCE OWNED BY "schema99.sequence2"
>> pg_restore: creating SEQUENCE "schema99.sequence2"
>>
>> Is your source database corrupted such that this duplication appears in
> its catalog?
>
> David J.
>
>