Streaming replication - slave server

Started by Tony Nelsonalmost 10 years ago2 messagesgeneral
Jump to latest
#1Tony Nelson
tnelson@starpoint.com

I have a nicely working 3 server, 1 master, 2 slave setup. All servers are running on Ubuntu 12.04. I was considering building a new slave server on 16.04.

The master is currently running 9.1.13, the slave I'm going to replace is running 9.1.20.

Does the new slave have to be running 9.1? Or can use the latest, which appears to be 9.5 on 16.04?

Thanks in advance,
Tony

Since 1982, Starpoint Solutions has been a trusted source of human capital and solutions. We are committed to our clients, employees, environment, community and social concerns. We foster an inclusive culture based on trust, respect, honesty and solid performance. Learn more about Starpoint and our social responsibility at http://www.starpoint.com/social_responsibility

This email message from Starpoint Solutions LLC is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Opinions, conclusions and other information in this message that do not relate to the official business of Starpoint Solutions shall be understood as neither given nor endorsed by it.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2Thomas Munro
thomas.munro@gmail.com
In reply to: Tony Nelson (#1)
Re: Streaming replication - slave server

On Tue, May 3, 2016 at 8:23 AM, Tony Nelson <tnelson@starpoint.com> wrote:

I have a nicely working 3 server, 1 master, 2 slave setup. All servers are running on Ubuntu 12.04. I was considering building a new slave server on 16.04.

The master is currently running 9.1.13, the slave I'm going to replace is running 9.1.20.

Does the new slave have to be running 9.1? Or can use the latest, which appears to be 9.5 on 16.04?

For binary streaming replication, the major version has to match. But
you aren't constrained to using the major version that ships with
Ubuntu: you could also use the community packages from here:

https://wiki.postgresql.org/wiki/Apt

The packages work the same way and as far as I know the same people
are involved in maintaining them.

BTW The latest 9.1.x is actually 9.1.21, and that major version
reaches EOL pretty soon:
http://www.postgresql.org/support/versioning/

--
Thomas Munro
http://www.enterprisedb.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general