PostgreSQL or Postgres is an open source object-relational database management system (ORDBMS) with more than 15 years of active development. It’s a powerful database server and can handle high workloads. PostgreSQL can be used on Linux, Unix, BSD and Windows servers.

Set Up Master-Slave Replication on PostgreSQL

PostgreSQL 9.5  Ubuntu 16.04

Database replication is the term we use to describe the technology used to maintain a copy of a set of data on a remote system. Keeping a reliable copy of a running system is one of the biggest concerns of redundancy and we all like maintainable, easy-to-use and stable copies of our data.

Typically, individual database servers are referred to as nodes. The whole group of database servers involved in replication is known as a cluster. A database server that allows a user to make changes is known as a master or primary or may be described as a source of changes. A database server that only allows read-only access is known as a Hot Standby.

Continue reading