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 MoreTag: how to
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
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
PostgreSql master-slave replication
prerequisite : master slave hardware specs we will be implement master-slave streaming replication using two VMS running ubuntu 22 jammyboth...
Read More
PostgreSql Maintenance in PostgreSQL
type of backup 1. logical backup A logical backup refers to the process of converting the data in a database...
Read More
Postgresql configuration files
postgresql.conf the file is located in data directory of the cluster default is located in /etc/postgresql/13/main/ check parameter of PostgreSQL inside...
Read More
PostgreSQL Directory layout
${toc} installation directory layout PostgreSQL is typicality installed to /usr/lib/postgresql/the same directory structure is the same both on windows and Linux.,now...
Read More
database cluster in PostgreSql
what is database cluster database cluster is collection of database managed by single instancedon’t get confused by cluster that tied...
Read More
Installing PostgreSQL on linux
Downloading package In the realm of Red Hat, we employ RPMs (Red Hat Package Manager) as a fundamental tool....
Read More