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

It doesn't show up twice based on these checks (Is there any other way I can check if the seq is showing up twice?).

 

I'll need to drop the table completely since the column is dependent on the seq, to fix forward. Wonder how/why the duplicates of create sequences.

On Mon, 2 Aug 2021 at 12:06, David G. Johnston <david.g.johnston@gmail.com> wrote:

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.