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
                                    List of installed extensions       Name        | Version |   Schema   |                        Description                        
--------------------+---------+------------+-----------------------------------------------------------pg_stat_statements | 1.1     | public     | track execution statistics of all SQL statements executedplpgsql            | 1.0     | pg_catalog | PL/pgSQL procedural language
(2 rows)

archive_old=# \c production
# \dx                                    List of installed extensions       Name        | Version |   Schema   |                        Description                        
--------------------+---------+------------+-----------------------------------------------------------hstore             | 1.1     | public     | data type for storing sets of (key, value) pairspg_stat_statements | 1.1     | public     | track execution statistics of all SQL statements executedplpgsql            | 1.0     | pg_catalog | PL/pgSQL procedural languageuuid-ossp          | 1.0     | public     | generate universally unique identifiers (UUIDs)
(4 rows)

Thanks,

On Thu, Feb 28, 2019 at 11:04 AM Sergei Kornilov <sk@zsrv.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