Postgres Pro
Downloads
Home   >   mailing lists

Upgrade master / slave - Mailing list pgsql-admin

From Bertrand
Subject Upgrade master / slave
Date
Msg-id 369807951.57268299.1443541581693.JavaMail.zimbra@kifaisa.com
Whole thread Raw
Responses Re: Upgrade master / slave  (Payal Singh <payal@omniti.com>)
List pgsql-admin
Tree view
Hello,

Currently I use MySQL 5.6 but I plan to migrate to PostgreSQL.
My application uses two databases : the total volume is 1TB on my hard drives.

I made some tests on PostgreSQL administration but I have a problem with Master / Slave.

How to update the cluster master / slave with a very short break time ?
I tried to update a slave (9.3 => 9.4) and connect it to the master 9.3 but it doesn't work.

If I have to stop the master, migrate it to 9.4, start it and repeat these steps for the slaves the breaking time is really long.

I thank you in advance.

Bertrand

pgsql-admin by date:

Previous
From: Stéphane Schildknecht
Date:
Subject: Re: Master / slave : major update
Next
From: Roman Shubovich
Date:
Subject: hot standby, how to disable WAL archiving ?