BryGom brygom

Download Boost Library from: http://www.boost.org (Choose the expected version)

wget https://cfhcable.dl.sourceforge.net/project/boost/boost/1.54.0/boost_1_54_0.tar.gz
wget https://phoenixnap.dl.sourceforge.net/project/boost/boost/1.58.0/boost_1_58_0.tar.gz
wget https://dl.bintray.com/boostorg/release/1.64.0/source/boost_1_64_0.tar.gz
wget https://dl.bintray.com/boostorg/release/1.65.1/source/boost_1_65_1.tar.gz

Unzip

WAL-E needs to be installed on all machines, masters and slaves.

How to install WAL-E

Only one machine, the master, writes WAL segments via continuous archiving. The configuration for the master postgresql.conf is:

archive_mode = on
archive_command = 'envdir /etc/wal-e.d/env wal-e wal-push %p'
archive_timeout = 60

	[template]
	src = "haproxy.cfg.tmpl"
	dest = "/etc/haproxy/haproxy.cfg"
	keys = [
	"/service",
	]
	reload_cmd = "echo restarting && service haproxy restart"

	scope: my-ha-cluster
	name: pg-2

	restapi:
	listen: 0.0.0.0:8008
	connect_address: 127.0.0.1:8008

	etcd:
	host: 127.0.0.1:2379

	scope: my-ha-cluster
	name: pg-1

	restapi:
	listen: 0.0.0.0:8008
	connect_address: 127.0.0.1:8008

	etcd:
	host: 127.0.0.1:2379

	global
	log /dev/log local0
	log /dev/log local1 notice
	chroot /var/lib/haproxy
	stats socket /run/haproxy/admin.sock mode 660 level admin
	stats timeout 30s
	user haproxy
	group haproxy
	daemon
	maxconn 100

	CREATE OR REPLACE FUNCTION ChangeObjectsOwnerShip(text)
	returns text language plpgsql volatile
	AS $c$
	BEGIN
	EXECUTE $1;
	RETURN $1;
	END;
	$c$;

	SELECT ChangeObjectsOwnerShip

	sudo /Library/PostgreSQL/9.6/uninstall-postgresql.app/Contents/MacOS/installbuilder.sh
	sudo rm -rf /Library/PostgreSQL
	sudo rm /etc/postgres-reg.ini