From: Bertrand <b.contacts@kifaisa.com>
To: pgsql-admin@postgresql.org
Subject: Upgrade master / slave
Date: Tue, 29 Sep 2015 17:46:21 +0200 (CEST)
Message-ID: <369807951.57268299.1443541581693.JavaMail.zimbra@kifaisa.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hello,
Currently I use MySQL 5.6 but I plan to migrate to PostgreSQL .
My application uses two databases : t he 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: b.contacts@kifaisa.com
Subject: Re: Upgrade master / slave
In-Reply-To: <369807951.57268299.1443541581693.JavaMail.zimbra@kifaisa.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox