Skip to main content

Posts

Showing posts from 2015

PostgreSQL 9.4 : Log shipping Standby Server setup (Step-by-step)

Consider following servers: Master (Production site, 10.88.66.225): Actual production Master site. Storage Server (10.88.66.27): Master would put WAL archived logs on Storage server from where the Slave would pick it up & restore. Slave (Hot Standby Server, 10.88.66.28): Slave would keep on restoring archived WAL files. This would be exact replica of production site. It would be use for read only queries & if production server crashes then Slave would take over the operations.    Steps for Replication setup: Install the PostgreSQL binary on both Master and Slave servers. Make sure disk mount points for data directory and tablespace directories are same on both the servers. For postgres user setup password less ssh connection between Master, storage and Slave; so that they could copy files across the network. Storage setup: Mount disks & Create storage Directory  Grand read-write permission to postgres user. Export this storage directory and open access to M