Re: pg_upgrade and wraparound

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(at)gmail(dot)com>:

> 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(dot)klaver(at)aklaver(dot)com>:
>
>> 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-f184378
>>> 0.html
>>>
>>>
>>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com
>>
>
>