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

Sharing more context on this: if I run

*/usr/pgsql-9.6/bin/pg_dump -d <db_name> -t public.auth_permission;*

I see multiple "CREATE SEQUENCE public.auth_permission_id_seq" commands.
This seems unusual.

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

On Mon, 2 Aug 2021 at 12:19, Dhanush D <dhanushdk94(at)gmail(dot)com> wrote:

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