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 MoreTag: dba guide
How to Capture SQL Server Deadlocks Using Extended Events
Deadlocks are one of the worst scenarios a DBA will face. They happen when two sessions are fighting for resources...
Read More
concurrency (dead-block , live blocking )
here we are referring to lock between deterrent userswhether the need lock how long they hold the locks . locks...
Read More
MySQL Storage Engines
Storage Engines MySQL supports a variety of table types to cater to different needs: To manage these diverse table types,...
Read More
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
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