| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Timokhin Maxim <ncx2(at)yandex(dot)com>, Melvin Davidson <melvin6925(at)gmail(dot)com>, "stevenchang1213(at)gmail(dot)com" <stevenchang1213(at)gmail(dot)com> |
| Cc: | "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 23:30:32 |
| Message-ID: | 43d3cc17-676f-59a6-8cbe-a46b2b3f2cc3@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 | Steven Chang | 2017-07-01 04:42:38 | Re: duplicate key value violates unique constraint and duplicated records |
| Previous Message | Adrian Klaver | 2017-06-30 23:21:09 | Re: PostGreSQL Timeout, auto shutdown and Pkey errors |