-
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-only). However, a key limitation
4 min read
-
upgrade postgresql
the upgrad decided to two part minor upgrade Each PostgreSQL version may require minor upgrades throughout its lifecycle to address critical bugs, enhance performance, or
4 min read
-
PostgreSql backup using pgbackrest
pgBackRest is a backup solution specifically designed for disaster recovery in PostgreSQL databases. Unlike other backup solutions like pg_dump, pgBackRest supports point-in-time recovery and offers
4 min read
-
PostgreSql stress testing database using pgbench
pgbench is tools that used to stress test database base on deferent scenarios you can define by simulating database traffic . pgbench can help use
4 min read
-
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 recommended to relocate the PostgreSQL
4 min read
-
PostgreSql logical replication
deferent than stream replication , where the master will send wall log , there we send the actual command such (insert into t1 values (1,”’value” ))
4 min read
blog
Visited 1,364 times, 1 visit(s) today