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.kla...@aklaver.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.kla...@aklaver.com >