Upgrade master / slave

From: Bertrand <b(dot)contacts(at)kifaisa(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Upgrade master / slave
Date: 2015-09-29 15:46:21
Message-ID: 369807951.57268299.1443541581693.JavaMail.zimbra@kifaisa.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bertrand 2015-09-29 15:49:19 Master / slave : major update
Previous Message CS DBA 2015-09-28 20:47:17 Re: repmgr error trying to clone - permission denied (SOLVED)