Oracle vs PostgreSQL – Transaction control statements

While migrating from Oracle to PostgreSQL, the important fact to consider is that they both are 2 different database engines. The major mistake made by organizations during the course of migration is assuming that the behavior of both Oracle and PostgreSQL are same.  One of such areas with differences between Oracle vs PostgreSQL is while working with Transaction

Read More »

Important PostgreSQL 14 update to avoid silent corruption of indexes

On June 16 2022, a new PostgreSQL 14 minor release will be published by the PostgreSQL Global Development Group. The new PostgreSQL 14.4 release fixes an issue with all versions of PostgreSQL 14 that can lead to silent corruption of indexes. Usually, the community announces a minor version update on the second Tuesday of the second month of

Read More »

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