Re: pg_upgrade and wraparound

[Alexander Shutyaev <shutyaev@xxxxxxxxx>]

Some more notes on databses.

Although the pg_upgrade failed, I've decided to check the databases in the new cluster (10.4). There is no database with oid 0 either. Also to be noted that some system databases changed the oids while others retained them.

And of my databases - sslentry. It had a very big oid (can that seem strange?) and its oid has changed.

select oid, datname from pg_database;

  oid  |  datname

-------+-----------

 13011 | template0

 16400 | bof

 13012 | postgres

 16401 | sslentry

     1 | template1

(5 rows)

2018-06-11 0:03 GMT+03:00 Alexander Shutyaev <shutyaev@xxxxxxxxx>:

No database with oid 0 in 9.6 cluster:

postgres=# select oid, datname from pg_database;

    oid     |  datname

------------+-----------

          1 | template1

      12438 | template0

      16400 | bof

      12439 | postgres

 1016305714 | sslentry

(5 rows)

>> 1) OS and version you are using?

Ubuntu 16.04.4

>> 2) Where are you getting you Postgres from?:
>>  a) Package
>>          Repo?
>>  b) Source
>>          File source?

I've installed it from postgresql repo -  http://apt.postgresql.org/pub/repos/apt/

>> 3) Where there any issues with 9.6 cluster before you tried to upgrade from it?

No, I don't remember anything specific about it.

2018-06-10 23:55 GMT+03:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx>:

On 06/10/2018 01:46 PM, Alexander Shutyaev wrote:

I can provide you with more info. Please tell me what you need. I really hope
someone here can help me somehow solve or workaround this, because I really
need to migrate to v10 for its features.

Well as Tom Lane said a database will not have an OID of 0, so we need to know where that is coming from. On the oft chance it occurred in your 9.6 cluster can you see if:

select oid, datname from pg_database;

in the 9.6 cluster shows an OID of 0.

Also:

1) OS and version you are using?

2) Where are you getting you Postgres from?:
a) Package
        Repo?
b) Source
        File source?

3) Where there any issues with 9.6 cluster before you tried to upgrade from it?

Thanks in advance,
Alexander



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx