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?).

[image: Screen Shot 2021-08-02 at 12.12.06 PM.png]

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(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> On Mon, Aug 2, 2021 at 11:42 AM Dhanush D <dhanushdk94(at)gmail(dot)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.
>
>