Re: pg_upgrade and wraparound

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
>