postgresql Setup replication using repmgr
Streaming replication is a common PostgreSQL high-availability setup, consisting of a primary server (read-write) and one or more standby replicas...
Read MoreTag: install
Using a Separate Data Directory for Your PostgreSQL Cluster
When installing PostgreSQL, it defaults to creating its data directory in /var/lib/postgresql. For better performance, reliability, and management, it is often...
Read More
PostgreSql logical replication
deferent than stream replication , where the master will send wall log , there we send the actual command such (insert...
Read More
How to failover stream replication in PostgreSQl
verify the replication on slave server before we start the failover , we need to verified the syn between the...
Read More
PostgreSql master-slave replication
prerequisite : master slave hardware specs we will be implement master-slave streaming replication using two VMS running ubuntu 22 jammyboth...
Read More
PostgreSql Maintenance in PostgreSQL
type of backup 1. logical backup A logical backup refers to the process of converting the data in a database...
Read More
PostgreSql backup and restore
${toc} type of backup 1. logical backup A logical backup refers to the process of converting the data in a...
Read More
PostgreSql table inheritance , table partion
table inheritance To convey the idea that child tables inherit all columns from the parent master table while also allowing...
Read More
Installing PostgreSQL on linux
Downloading package In the realm of Red Hat, we employ RPMs (Red Hat Package Manager) as a fundamental tool....
Read More