Handling Trailing Zeros With Numeric Datatype in PostgreSQL

While performing Oracle to Postgres migrations, we may come across many interesting conversion challenges. Sometimes, the same logic might produce a different behavior between Oracle and Postgres. Minor mistakes in such conversions may create a lot of work while fixing the application functionality. One of such mistakes is while handling trailing zeroes with numeric datatype in PostgreSQL, during

Read More »

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 »
Scroll to Top