Postgres Pro
Downloads
Home   >   mailing lists

Master / slave : major update - Mailing list pgsql-admin

From Bertrand
Subject Master / slave : major update
Date
Msg-id 758691866.57285254.1443541759806.JavaMail.zimbra@kifaisa.com
Whole thread Raw
Responses Re: Master / slave : major update
List pgsql-admin
Tree view
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 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

pgsql-admin by date:

Previous
From: CS DBA
Date:
Subject: Re: repmgr error trying to clone - permission denied (SOLVED)
Next
From: Stéphane Schildknecht
Date:
Subject: Re: Master / slave : major update