Tag: tag

Automating PostgreSQL master-slave replication setup using makefile with pg_createcluster and pg_ctlcluster utilities

Automating Master and slave replication: PostgreSQL – I

Posted on by Sanjeeva Kumar

Master-slave replication setup is the implementation of HA in PostgreSQL. Deployment architecture of 1 master and at least one slave in SYNC mode would be able to provide senses of High Availability of the database. To achieve this we require some steps to be performed into the database which will make one of the nodes Read more about Automating Master and slave replication: PostgreSQL – I[…]

PostgreSQL database cluster concept showing one instance managing multiple databases including default postgres, template0, template1

What is a Database Cluster: PostgreSQL

Posted on by Sanjeeva Kumar

In the last blog, we have installed PostgreSQL on different Linux platforms ( CentOs, Ubuntu). However, We have leftover to initialize the installation and connection to the database that we will discuss here. Postgres provides more than one way to initialize a database cluster. We will use pg_createcluster in this blog. But before that, we Read more about What is a Database Cluster: PostgreSQL[…]