Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZgyY7-0007qv-Bx for pgsql-admin@arkaria.postgresql.org; Tue, 29 Sep 2015 17:18:43 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZgyY6-0000v5-TH for pgsql-admin@arkaria.postgresql.org; Tue, 29 Sep 2015 17:18:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1Zgx9i-0000St-IZ for pgsql-admin@postgresql.org; Tue, 29 Sep 2015 15:49:26 +0000 Received: from mail-01.akseo.net ([85.93.215.167] helo=mx0.akseo.fr) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1Zgx9f-0002Tp-Pv for pgsql-admin@postgresql.org; Tue, 29 Sep 2015 15:49:26 +0000 Received: from localhost (localhost [127.0.0.1]) by mx0.akseo.fr (Postfix) with ESMTP id 3A63810C002D for ; Tue, 29 Sep 2015 17:46:27 +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 qMX9avtw5fZM for ; Tue, 29 Sep 2015 17:46:22 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by mx0.akseo.fr (Postfix) with ESMTP id 1DA7010C007F for ; Tue, 29 Sep 2015 17:46:22 +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 6J8SHiP1-odz for ; Tue, 29 Sep 2015 17:46:22 +0200 (CEST) Received: from mx0.akseo.fr (mx0.akseo.fr [85.93.215.167]) by mx0.akseo.fr (Postfix) with ESMTP id DF64510C004F for ; Tue, 29 Sep 2015 17:46:21 +0200 (CEST) Date: Tue, 29 Sep 2015 17:46:21 +0200 (CEST) From: Bertrand To: pgsql-admin@postgresql.org Message-ID: <369807951.57268299.1443541581693.JavaMail.zimbra@kifaisa.com> Subject: Upgrade master / slave MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_57268298_1513823006.1443541581693" 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: Upgrade master / slave Thread-Index: afwUd+K9LsR9Jml9WCzlCl53ZSlikQ== X-Pg-Spam-Score: -1.9 (-) 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_57268298_1513823006.1443541581693 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_57268298_1513823006.1443541581693 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<= /span> 1TB on my hard drives.

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

How to upd= ate the cluster maste= r / 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.

Bertrand
------=_Part_57268298_1513823006.1443541581693--