From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | Timokhin Maxim <ncx2(at)yandex(dot)com>, stevenchang1213(at)gmail(dot)com, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: duplicate key value violates unique constraint and duplicated records |
Date: | 2017-06-30 13:28:02 |
Message-ID: | CANu8FiwPxwZ5vvk3voGC6hiE6LD+R2WpY=OmJiur6xga-4-DJQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Jun 30, 2017 at 9:07 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> On 06/30/2017 04:58 AM, Timokhin Maxim wrote:
>
>> BTW, we are moving using:
>>
>> pg_basebackup -h servername -R -P -D /data/upgrade/94 -U pgsql -v
>> —xlog-method=stream —checkpoint=fast
>>
>
> Going from 9.4 to 9.6 is a major version upgrade and you cannot use
> pg_basebackup for that. Besides I can't see how you even got the 9.6.3
> server to start:
>
> /usr/local/pgsql94/bin/pg_basebackup -D /home/aklaver/pgback_test94 -U
> postgres -p 5412 -v --xlog-method=stream
>
> /usr/local/pgsql96/bin/pg_ctl -D /home/aklaver/pgback_test94/ start
> server starting
> FATAL: database files are incompatible with server
> DETAIL: The data directory was initialized by PostgreSQL version 9.4,
> which is not compatible with this version 9.6.3
>
>
>> After that we are upping version to 9.6.3.
>>
>
> Given the above how did you actually get 9.6.3 to start?
>
>
> I've looked through the documentation https://postgrespro.ru/docs/po
>> stgrespro/9.6/app-pgbasebackup and didn't find details about how
>> pg_basebackup works with b-tree indexes.
>> Is it possible that pg_basebackup just copies indexes as is and that is
>> cause of corruption. Or it pass indexes as instruction that says "after
>> upping db make indexes" ?
>>
>> Thank you.
>>
>>
>> --
>> Timokhin 'maf' Maxim
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
*Since you are doing a major version upgrade, the correct way to do that,
depending on the size of your DB, is *
*A. pg_dumpall on old version and pg_reload on new version*
*OR*
*B. pg_upgrade*
*https://www.postgresql.org/docs/9.6/static/upgrading.html
<https://www.postgresql.org/docs/9.6/static/upgrading.html>*--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
From | Date | Subject | |
---|---|---|---|
Next Message | Timokhin Maxim | 2017-06-30 14:33:42 | Re: duplicate key value violates unique constraint and duplicated records |
Previous Message | Adrian Klaver | 2017-06-30 13:07:00 | Re: duplicate key value violates unique constraint and duplicated records |