Hi Sergei and Team Could you share your observation further.
Perumal Raju On Thu, Feb 28, 2019, 11:21 AM Perumal Raj <peruci...@gmail.com> wrote: > 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 executed > plpgsql | 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) 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 >> >
