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