On 06/30/2017 09:42 PM, Steven Chang wrote:
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.
That is interesting, more information would be helpful though:
Postgres version?
OS and version?
The pg_basebackup command line invocation?
Why you don't think it is index corruption?
2017-07-01 7:30 GMT+08:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>>:
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
<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.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
