DBA expertise: PostgreSQL, SQL Server & MySQL
pgEdge delivers multi-primary (aka master-master) Postgres replication, so every node is read/write. Unlike Patroni or traditional streaming replication—where one primary handles writes and the rest are read-only—pgEdge lets all nodes accept writes. That enables true geo-distribution for lower latency and better performance, and it simplifies operations: fewer failovers, less downtime, and no single leader to…
PostgreSQL Performance Tuning Lab with pg_profile and pgbench Steps if you looking to get oracle AWR report in postgresql look no further than using pg_profile , its extension help you get full statistics report of postgresql instance that you view in your browser to check lots of statistics regarding I/O memory blocking and long running…
I had a scenario where the data team needed all tables from different databases to be combined into a single database for reporting and analysis using a tool like Metabase. Initially, I faced challenges trying to restore tables into a single database manually, which led to several issues. However, I discovered pgloader, a tool typically used…
Configuring Patroni can be challenging and time-consuming, but thanks to Autobase, the deployment process becomes much easier. Whether you’re deploying on-premises or in the cloud, such as Google Cloud or Amazon Web Services, Autobase simplifies the process. With Autobase’s console UI, you simply enter your server information and select the version you want, and then…
One of the key tasks for any PostgreSQL DBA is conducting daily health checks to ensure the database remains healthy. Performing these checks is critical as it helps identify potential issues and resolve them before they impact production. PostgreSQL provides several views to monitor various metrics such as wait states, CPU usage, I/O, and more….
Tracking any changes made at the database level is crucial for holding accountable any users with access to PostgreSQL. During my experience as a database administrator, I encountered two situations where applications reported data loss. Upon investigation, we discovered that a table had been truncated. Unfortunately, we couldn’t confirm the source of the issue because…
backup We will use pg_basebackup to take a complete backup of the PostgreSQL data directory. A separate directory will be created for storing backups, preferably on a separate mount point. The ownership of this directory will be assigned to the postgres user to ensure proper permissions. sudo mkdir -p /db_backup/base_backup sudo chown -R postgres:postgres db_backup/ Log in as the postgres user…
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 is that it doesn’t automatically failover to a replica if the primary server goes down, requiring manual intervention from a DBA to promote the replica to read-write…
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. It’s a best practice to review the release notes and test the new build in a non-production environment before applying it to your production system.additionally you should…
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. pgBackRest can perform three types of backups: installing and configuring We will begin by installing pgBackRest on an Ubuntu Server 22 using the following command: sudo apt…