Federico87 lvrfrc87

## master-postgres-9.6-hot-standby.sh

MASTER_IP=
SLAVE_IP=

# service postgresql stop
su - postgres
psql -c "CREATE ROLE replica WITH PASSWORD 'myreplpassword' LOGIN REPLICATION;"

#Security for master allow standby access
echo "host replication replica $SLAVE_IP/32 md5" >> /etc/postgresql/9.6/main/pg_hba.conf

	MASTER_IP=
	SLAVE_IP=

	# service postgresql stop
	su - postgres
	psql -c "CREATE ROLE replica WITH PASSWORD 'myreplpassword' LOGIN REPLICATION;"

	#Security for master allow standby access
	echo "host replication replica $SLAVE_IP/32 md5" >> /etc/postgresql/9.6/main/pg_hba.conf