pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bertrand <b.contacts@kifaisa.com>
To: pgsql-admin@postgresql.org
Subject: Master / slave : major update
Date: Tue, 29 Sep 2015 17:49:19 +0200 (CEST)
Message-ID: <758691866.57285254.1443541759806.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 

view thread (2+ messages)  latest in thread

Message-ID: <758691866.57285254.1443541759806.JavaMail.zimbra@kifaisa.com>
Permalink:  ../758691866.57285254.1443541759806.JavaMail.zimbra@kifaisa.com/
Also on:    postgresql.org/message-id/758691866.57285254.1443541759806.JavaMail.zimbra@kifaisa.com

 · 

reply

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: Master / slave : major update
  In-Reply-To: <758691866.57285254.1443541759806.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