Re: [ADMIN] Can master and slave on different PG versions?

Поиск
Список
Период
Сортировка
От Scott Mead
Тема Re: [ADMIN] Can master and slave on different PG versions?
Дата
Msg-id B193043A-AEFA-41A5-A45D-5A80839DB413@openscg.com
обсуждение исходный текст
Ответ на Re: [ADMIN] Can master and slave on different PG versions?  (rammohan ganapavarapu <rammohanganap@gmail.com>)
Список pgsql-admin
Дерево обсуждения


On Oct 10, 2017, at 11:49, rammohan ganapavarapu <rammohanganap@gmail.com> wrote:

I am getting this error when i try to add 9.6 slave to 9.4 master.

< 2017-10-09 22:56:31.081 UTC > FATAL: database files are incompatible with server < 2017-10-09 22:56:31.081 UTC > DETAIL: The data directory was initialized by PostgreSQL version 9.4, which is not compatible with this version 9.6.1.

Ram

No, you cannot do that with physical streaming replication.  They must be the same major version number. 9.5 -> 9.5.  


On Tue, Oct 10, 2017 at 8:26 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On Mon, Oct 9, 2017 at 5:06 PM, rammohan ganapavarapu
<rammohanganap@gmail.com> wrote:
> Hi,
>
> Is it possible to add 9.6 version Slave to 9.4 master?

Standard usage for Slony. I've used it for dozens of upgrades in place
with a few seconds switch over time.  It's not as complex as it first
appears, but test on something other than production please.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [ADMIN] FQDN for replication connection in pg_hba.conf
Следующее
От: Don Seiler
Дата:
Сообщение: [ADMIN] Passwords in clear text in server log