[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] duplicate key value violates unique constraint and duplicated records
From:       Adrian Klaver <adrian.klaver () aklaver ! com>
Date:       2017-06-30 23:30:32
Message-ID: 43d3cc17-676f-59a6-8cbe-a46b2b3f2cc3 () aklaver ! com
[Download RAW message or body]

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.klaver@aklaver.com


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[prev in list] [next in list] [prev in thread] [next in thread]