Re: Question about pg_upgrade from 9.2 to X.X

here is the data,

postgres=# \c template1
You are now connected to database "template1" as user "postgres".
template1=# \dx
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(1 row)

template1=# \c postgres
You are now connected to database "postgres" as user "postgres".
postgres=# \dx
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(1 row)

postgres=# \c nagdb
You are now connected to database "nagdb" as user "postgres".
nagdb=# \dx
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(1 row)

nagdb=# \c archive_old
You are now connected to database "books_old" as user "postgres".
books_old=# \dx
List of installed extensions
Name | Version | Schema |
Description
--------------------+---------+------------+-----------------------------------------------------------
pg_stat_statements | 1.1 | public | track execution
statistics of all SQL statements executed
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(2 rows)

archive_old=# \c production
You are now connected to database "blurb_production" as user "postgres".
production=# \dx
List of installed extensions
Name | Version | Schema |
Description
--------------------+---------+------------+-----------------------------------------------------------
hstore | 1.1 | public | data type for storing
sets of (key, value) pairs
pg_stat_statements | 1.1 | public | track execution
statistics of all SQL statements executed
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
uuid-ossp | 1.0 | public | generate universally
unique identifiers (UUIDs)
(4 rows)

Thanks,

On Thu, Feb 28, 2019 at 11:04 AM Sergei Kornilov <sk(at)zsrv(dot)org> wrote:

> Hi
>
> > Yes, i want to get rid of old extension, Could you please share the
> query to find extension which is using pg_reorg.
>
> pg_reorg is name for both tool and extension.
> Check every database in cluster with, for example, psql command "\dx" or
> read pg_dumpall -s output for some CREATE EXTENSION statements to find all
> installed extensions.
>
> regards, Sergei
>