Re: pg_upgrade and wraparound

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: pg_upgrade and wraparound
Дата
Msg-id bc010ee6-4183-b11d-e401-33b5d67ed8fe@aklaver.com
обсуждение исходный текст
Ответ на Re: pg_upgrade and wraparound  (Alexander Shutyaev <shutyaev@gmail.com>)
Ответы Re: pg_upgrade and wraparound
Список pgsql-general
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@aklaver.com


В списке pgsql-general по дате отправления:

Предыдущее
От: Devrim Gündüz
Дата:
Сообщение: Re: Failed rpm package signature checks with reposync
Следующее
От: Alexander Shutyaev
Дата:
Сообщение: Re: pg_upgrade and wraparound