How to install pgEdge Distributed Postgres
pgEdge delivers multi-primary (aka master-master) Postgres replication, so every node is read/write. Unlike Patroni or traditional streaming replication—where one primary...
Read MoreCategory: PostgreSql
Performance Tuning with pg_profile and pgbench
PostgreSQL Performance Tuning Lab with pg_profile and pgbench Steps if you looking to get oracle AWR report in postgresql look...
Read More
pgloader for migrating for postgresql
I had a scenario where the data team needed all tables from different databases to be combined into a single...
Read More
automate patroni deployment using partoni autobase
Configuring Patroni can be challenging and time-consuming, but thanks to Autobase, the deployment process becomes much easier. Whether you’re deploying...
Read More
Health check using pgmetrics
One of the key tasks for any PostgreSQL DBA is conducting daily health checks to ensure the database remains healthy....
Read More
auditing in postgresql
Tracking any changes made at the database level is crucial for holding accountable any users with access to PostgreSQL. During...
Read More
PostgreSql maintenance schedule
backup We will use pg_basebackup to take a complete backup of the PostgreSQL data directory. A separate directory will be created for...
Read More
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 More
upgrade postgresql
the upgrad decided to two part minor upgrade Each PostgreSQL version may require minor upgrades throughout its lifecycle to address...
Read More
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...
Read More