From: | Steven Chang <stevenchang1213(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | Timokhin Maxim <ncx2(at)yandex(dot)com>, Melvin Davidson <melvin6925(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-07-01 04:42:38 |
Message-ID: | CAEJt7k3a2h806pjngLtifSfPgaJEjkMRvtC0irFYaz1JQ1BFJw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Uh...we also met duplicate rows with primary key column through restoring
database by pg_basebackup.
HAAAA.........................
I don't think its an issue with primary key index corruption.
2017-07-01 7:30 GMT+08:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:
> On 06/30/2017 07:33 AM, Timokhin Maxim wrote:
>
>> Sure, here it is.
>>
>> pg_basebackup -h servername -R -P -D /data/upgrade/94 -U pgsql -v
>> —xlog-method=stream —checkpoint=fast
>>
>> /usr/pgsql-9.5/bin/initdb -D /data/upgrade/95/ —encoding=utf8
>> —locale=ru_RU.utf8 —lc-collate=ru_RU.utf8 —lc-ctype=ru_RU.utf8
>> —lc-messages=en_US.utf8
>>
>> Then updating:
>> /usr/pgsql-9.5/bin/pg_upgrade -b /usr/pgsql-9.4/bin/ -d /data/upgrade/94
>> -B /usr/pgsql-9.5/bin/ -D /data/upgrade/95 -k
>>
>> and so on to 9.6
>>
>
> The original 9.4 database has the same encoding setup?
>
> FYI, you can use pg_upgrade to go straight from 9.4 to 9.6.
>
> https://www.postgresql.org/docs/9.6/static/pgupgrade.html
>
> "pg_upgrade supports upgrades from 8.4.X and later to the current major
> release of PostgreSQL, including snapshot and alpha releases."
>
>
>
>> after that server starts normally.
>>
>>
>> --
>> Timokhin 'maf' Maxim
>>
>>
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
From | Date | Subject | |
---|---|---|---|
Next Message | rajan | 2017-07-01 06:32:28 | have trouble understanding xmin and xmax with update operations from two different sessions |
Previous Message | Adrian Klaver | 2017-06-30 23:30:32 | Re: duplicate key value violates unique constraint and duplicated records |