Re: Question about pg_upgrade from 9.2 to X.X

Hi Sergei and Team

Could you share your observation further.

Perumal Raju

On Thu, Feb 28, 2019, 11:21 AM Perumal Raj <perucinci(at)gmail(dot)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 <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
>>
>