Re: Question about pg_upgrade from 9.2 to X.X
| От | Perumal Raj |
|---|---|
| Тема | Re: Question about pg_upgrade from 9.2 to X.X |
| Дата | |
| Msg-id | CALvqh4ohYLpVyR8Fm8Sxd_8yoFv=2xAMbxG0AKMpNrBgXQPUhA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Question about pg_upgrade from 9.2 to X.X (Sergei Kornilov <sk@zsrv.org>) |
| Ответы |
Re: Question about pg_upgrade from 9.2 to X.X
(Perumal Raj <perucinci@gmail.com>)
|
| Список | pgsql-hackers |
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 executedplpgsql | 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) 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
В списке pgsql-hackers по дате отправления: