pgBackRest – Running Backup from a Standby Server

In our previous blog post, we discussed how to set up pgBackrest on a single standalone PostgreSQL Instance. When you run backups on a Primary Instance, we would be utilizing the computing power of the primary instance that takes the WRITES traffic. For this reason, one may choose to shift the backup job from primary to standby. These

Read More »

pgBackRest – Restoring a Backup from a backup Repository

In one of our articles on pgBackRest, we have discussed how to setup a robust backup strategy using pgBackrest. However, it is also important to know how to restore and test our backups for the purpose of recoverability. This makes sure that we have proper backup and if a need arises, we can restore the backup as of

Read More »

Contributions by MigOps to PostgreSQL in 2021

Our team at MigOps, believes that the increasing open source contributions to the PostgreSQL ecosystem is the major reason for increased migrations to PostgreSQL. Several developers across the world have been spending a lot of their personal and professional time to keep the beauty of this Open Source database software active. Some organizations have even hired developers to

Read More »

A short summary of the Year 2021 in the PostgreSQL ecosystem

On behalf of the PostgreSQL community and the team at MigOps, we wish all the readers a very Happy New Year – 2022. It is no wonder that PostgreSQL is the only Open Source database with a consistent increase in its adoption every year. The Year 2021 has been another milestone in the PostgreSQL world. Every user of

Read More »

Is Aurora PostgreSQL really faster and cheaper than RDS PostgreSQL – Benchmarking

This article is to help you understand that you should benchmark before choosing Aurora PostgreSQL over PostgreSQL. We have often noticed that a lot of Customers migrating from Oracle to PostgreSQL get confused between PostgreSQL and Aurora PostgreSQL. Majority of leaders and key decision makers incline towards Aurora PostgreSQL as it is often marketed as 3 times faster

Read More »

PostgreSQL 15 will include some more regexp functions

While migrating from other databases like Oracle to PostgreSQL, we may come across some functionalities that may be only available with a complex work-around. At MigOps, we have migrated many customers from Oracle to PostgreSQL and I have personally seen many scenarios where direct equivalent is not possible. One of them was while working with regular expressions. There

Read More »
Scroll to Top