Re: Postgres 9.6 to 12.7 pg_upgrade error - terminating connection due to administrator command - Mailing list pgsql-general

From David G. Johnston
Subject Re: Postgres 9.6 to 12.7 pg_upgrade error - terminating connection due to administrator command
Date
Msg-id CAKFQuwbC-ZJDsY3e26c4zj6_iF7nmCGNPSUkcSAEni=Hdrecew@mail.gmail.com
Whole thread Raw
In response to Postgres 9.6 to 12.7 pg_upgrade error - terminating connection due to administrator command  (Dhanush D <dhanushdk94@gmail.com>)
Responses Re: Postgres 9.6 to 12.7 pg_upgrade error - terminating connection due to administrator command
List pgsql-general
On Mon, Aug 2, 2021 at 11:42 AM Dhanush D <dhanushdk94@gmail.com> wrote:
Multiple "Create sequence" and "Drop sequence". However the drop sequence doesn't seem to drop the sequence cleanly hence failing the restore process.

It shouldn't be dropping at all - it assumes it is starting from an empty slate.

Same question as before, on the 9.6 instance, does this sequence actually show up twice?  If so, how it came to be that way might be interesting, and others may wish to investigate, but ultimately one of the two would have to be removed (not something I feel qualified to walk someone else through via email) from the 9.6, after which the upgrade should get past that point.

David J.

pgsql-general by date:

Previous
From: Dhanush D
Date:
Subject: Re: Postgres 9.6 to 12.7 pg_upgrade error - terminating connection due to administrator command
Next
From: Dhanush D
Date:
Subject: Re: Postgres 9.6 to 12.7 pg_upgrade error - terminating connection due to administrator command