From: Stéphane Schildknecht <stephane.schildknecht@postgres.fr>
To: pgsql-admin@postgresql.org
Subject: Re: Master / slave : major update
Date: Tue, 29 Sep 2015 18:46:35 +0200
Message-ID: <560AC06B.50605@postgres.fr> (raw)
In-Reply-To: <758691866.57285254.1443541759806.JavaMail.zimbra@kifaisa.com>
References: <758691866.57285254.1443541759806.JavaMail.zimbra@kifaisa.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 29/09/2015 17:49, Bertrand wrote:
> Hello,
>
> Currently I use MySQL 5.6 but I plan to migrate to PostgreSQL.
> My application uses two databases : the total volume is 1TBon 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
Hello,
There is, currently no possibility to use streaming replication for 9.3 -> 9.4
upgrade.
You should have a look at pg_upgrade, which may allow you to do a (quite) fast
migration, if using hard link option.
Or use a tool like slony to do 9.3->9.4 replication system, and then switchover.
Best regards,
--
Stéphane Schildknecht
Contact régional PostgreSQL pour l'Europe francophone
Loxodata - Conseil, expertise et formations
06.17.11.37.42
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: stephane.schildknecht@postgres.fr
Subject: Re: Master / slave : major update
In-Reply-To: <560AC06B.50605@postgres.fr>
* 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