Hello.We are in process moving to new db from 9.4.8 -> 9.6.3.1. When we did it our application started to throw exception "duplicate key value violates unique constraint" during doing INSERT: INSERT INTO items (ctime, mtime, pubdate, url, title, description, body, status, fulltext_status, orig_id,
30.06.2017, 00:22, "Melvin Davidson" :
> On Thu, Jun 29, 2017 at 5:28 AM, Timokhin Maxim wrote:
>> Hello.
>> We are in process moving to new db from 9.4.8 -> 9.6.3.1. When we did it our
>> application started to throw exception "duplicate key value violate
а!Используйте кнопку "ответить всем".Не удаляйте историю переписки.Спасибо. С уважением, Timokhin 'maf' Maxim 30.06.2017, 00:22, "Melvin Davidson" : On Thu, Jun 29, 2017 at 5:28 AM, Timokhin Maxim <n...@yandex.com> wrote:Hello.We are in process moving to new
Yes, you are right. It's just a typo. -- Пожалуйста!Используйте кнопку "ответить всем".Не удаляйте историю переписки.Спасибо. С уважением, Timokhin 'maf' Maxim 30.06.2017, 02:38, "Adrian Klaver" :On 06/29/2017 02:28 AM, Timokhin Maxim wrote: Hello. We are in
/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
after that server starts normally.
--
Timokhin 'maf' Maxim
30.06.2017, 16:07, "Adrian Klaver" :
> On 06/30/2017 04:58 AM, Timokhin Maxim
уважением, Timokhin 'maf' Maxim
30.06.2017, 17:33, "Timokhin Maxim" :
> 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/
