-
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 master and slave in the slave run the…
4 min read
-
PostgreSql master-slave replication
prerequisite : master slave hardware specs we will be implement master-slave streaming replication using two VMS running ubuntu 22 jammyboth node will have PostgreSQL 12 installed , and…
4 min read
-
PostgreSql Maintenance in PostgreSQL
type of backup 1. logical backup A logical backup refers to the process of converting the data in a database into a straightforward text format. This typically involves…
4 min read
-
PostgreSql backup and restore
${toc} type of backup 1. logical backup A logical backup refers to the process of converting the data in a database into a straightforward text format. This typically…
4 min read
-
PostgreSql tablespace
PostgreSQL store data logically in tablespace and physically in datafilesPostgreSQL uses a tablespace to map a logical name to a physical location on disk tablespace allow the user…
4 min read
-
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 child tables to have additional fields, with the…
4 min read
blog
Visited 1,290 times, 1 visit(s) today