Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZgxEF-00049U-Qy for pgsql-admin@arkaria.postgresql.org; Tue, 29 Sep 2015 15:54:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZgxEF-0003HG-DF for pgsql-admin@arkaria.postgresql.org; Tue, 29 Sep 2015 15:54:07 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZgxCc-0001Rq-1m for pgsql-admin@postgresql.org; Tue, 29 Sep 2015 15:52:26 +0000 Received: from mail-01.akseo.net ([85.93.215.167] helo=mx0.akseo.fr) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZgxCU-0003hI-9E for pgsql-admin@postgresql.org; Tue, 29 Sep 2015 15:52:24 +0000 Received: from localhost (localhost [127.0.0.1]) by mx0.akseo.fr (Postfix) with ESMTP id EC1BB10C002D for ; Tue, 29 Sep 2015 17:49:20 +0200 (CEST) Received: from mx0.akseo.fr ([127.0.0.1]) by localhost (mx0.akseo.fr [127.0.0.1]) (amavisd-new, port 10032) with ESMTP id lFmx-gCjLC3w for ; Tue, 29 Sep 2015 17:49:20 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by mx0.akseo.fr (Postfix) with ESMTP id 1E53110C003F for ; Tue, 29 Sep 2015 17:49:20 +0200 (CEST) X-Virus-Scanned: amavisd-new at mx0.akseo.fr Received: from mx0.akseo.fr ([127.0.0.1]) by localhost (mx0.akseo.fr [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id HUq-v_8F2aJY for ; Tue, 29 Sep 2015 17:49:20 +0200 (CEST) Received: from mx0.akseo.fr (mx0.akseo.fr [85.93.215.167]) by mx0.akseo.fr (Postfix) with ESMTP id EAD3610C002D for ; Tue, 29 Sep 2015 17:49:19 +0200 (CEST) Date: Tue, 29 Sep 2015 17:49:19 +0200 (CEST) From: Bertrand To: pgsql-admin@postgresql.org Message-ID: <758691866.57285254.1443541759806.JavaMail.zimbra@kifaisa.com> Subject: Master / slave : major update MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_57285253_1419240871.1443541759805" X-Originating-IP: [195.218.31.163] X-Mailer: Zimbra 8.6.0_GA_1178 (ZimbraWebClient - FF40 (Linux)/8.6.0_GA_1178) Thread-Topic: Master / slave : major update Thread-Index: O9OHQzv8UBedAJl3B0i3lDmH5uuRYg== X-Pg-Spam-Score: -0.5 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ------=_Part_57285253_1419240871.1443541759805 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit 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 ------=_Part_57285253_1419240871.1443541759805 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
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 driv= es.
=
I made some tests on PostgreS= QL administration but I have a problem with Master / Slave.

<= span id=3D"result_box" class=3D"" lang=3D"en">How to update the cluster master / slave with a very short break time ?
I tried to update a slave (9.3 =3D= > 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.

Ber= trand
------=_Part_57285253_1419240871.1443541759805--