-
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 of streaming replication…
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 mitigate security vulnerabilities.…
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 many additional features.…
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 also now our…
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 data directory to…
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” )) physical replication in…
4 min read
blog
Visited 1,554 times, 1 visit(s) today