Message-ID: <560AC06B.50605@postgres.fr>
Date: Tue, 29 Sep 2015 18:46:35 +0200
From: =?UTF-8?B?U3TDqXBoYW5lIFNjaGlsZGtuZWNodA==?=
 <stephane.schildknecht@postgres.fr>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:31.0) Gecko/20100101 Icedove/31.8.0
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: Master / slave : major update
References: <758691866.57285254.1443541759806.JavaMail.zimbra@kifaisa.com>
In-Reply-To: <758691866.57285254.1443541759806.JavaMail.zimbra@kifaisa.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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