PostgreSql logical replication
deferent than stream replication , where the master will send wall log , there we send the actual command such (insert...
Read MoreTag: postgresql
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
Postgresql configuration files
postgresql.conf the file is located in data directory of the cluster default is located in /etc/postgresql/13/main/ check parameter of PostgreSQL inside...
Read More
PostgreSQL Directory layout
${toc} installation directory layout PostgreSQL is typicality installed to /usr/lib/postgresql/the same directory structure is the same both on windows and Linux.,now...
Read More
database cluster in PostgreSql
what is database cluster database cluster is collection of database managed by single instancedon’t get confused by cluster that tied...
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