Postgres Pro
Downloads
Home   >   mailing lists

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 CAKFQuwZmqZBOQU=b9K_+dt5W5zQBm96kce=_KAwZEXwzpuBkXQ@mail.gmail.com
Whole thread Raw
In response to Re: Postgres 9.6 to 12.7 pg_upgrade error - terminating connection due to administrator command  (Dhanush D <dhanushdk94@gmail.com>)
List pgsql-general
Tree view
On Mon, Aug 2, 2021 at 12:20 PM Dhanush D <dhanushdk94@gmail.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?).


 SELECT * FROM pg_class WHERE relkind = 'S' AND relname ~ 'permission';

I made the "relname" a bit broad, you should see the exact name (add an order by...).  relkind=S are sequences.

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: Vikas Sharma
Date:
Subject: pgcrypto - real life examples to encrypt / decrypt