pgBackRest – The Best Postgres Backup Tool with a very active community

A reliable backup tool with an ability to perform a point in time recovery (PITR) is a usual enterprise need. Postgres includes a backup tool called pg_basebackup for full backups. It is great for a database of a few hundreds of GBs in size but currently lacks the support for parallel, incremental and differential backups. This makes it

Read More »

Handling Global Associative Arrays in PostgreSQL

While migrating from Oracle to PostgreSQL, most of the developers ask about the options available in Handling Global associative arrays in PostgreSQL. It might get challenging if the variables need to be accessible in the Exception block. To avoid developers from finding it difficult while performing conversions of PL/SQL from Oracle to PostgreSQL, we are writing this blog

Read More »

A Bug on Aurora PostgreSQL 12 causes Autovacuum to hang forever

Amazon recently announced the release of Aurora PostgreSQL 12. This announcement may have encouraged several customers to upgrade from their existing Aurora PostgreSQL 10.x or 11.x to Aurora PostgreSQL 12.4. The Community PostgreSQL 12 has been one of the greatest releases ever with a big list of features and performance optimizations. So, it may be fair to assume

Read More »

Role of Foreign Data Wrappers in Migrations to PostgreSQL

Millions of databases are being migrated to PostgreSQL today. This is because of the liberal PostgreSQL license in particular that invited more contributions to PostgreSQL and eventually made it Enterprise Grade. I have presented and also blogged about some of the rich enterprise features as following, those are otherwise available for an additional cost with some commercial databases.

Read More »
Scroll to Top