Re: PostgreSQL upgrade.

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: PostgreSQL upgrade.
Дата
Msg-id 7e7a988f-0493-8741-199e-529eb68a4d3e@a-kretschmer.de
обсуждение исходный текст
Ответ на PostgreSQL upgrade.  (Daulat Ram <Daulat.Ram@exponential.com>)
Ответы Re: PostgreSQL upgrade.  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Список pgsql-performance

Am 10.04.19 um 07:40 schrieb Daulat Ram:
> We have two node postgresql database version 9.6 with streaming 
> replication which is running on docker environment, os Linux (Ubuntu) 
> and we have to migrate on PostgresQL11. I need your suggestions & 
> steps to compete the upgrade  process successfully.

there are exists several ways to do that. You can take a normal dump and 
replay it in the new version, you can use pg_upgrade, and you can use a 
logical replication (using slony, londiste or pg_logical from 
2ndQuadrant). There is no 'standard way' to do that, all depends on your 
requirements and knowledge how to work with that tools.


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com




В списке pgsql-performance по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Commit(?) overhead
Следующее
От: Gunther
Дата:
Сообщение: Out of Memory errors are frustrating as heck!