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

[Dhanush D <dhanushdk94@xxxxxxxxx>]

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:
 

The dump file has something like this: 

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.g.johnston@xxxxxxxxx> wrote:

On Friday, July 30, 2021, Dhanush D <dhanushdk94@xxxxxxxxx> 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.