DR DB support features supported in PostgreSQL

PostgreSQL
1

Hi All,

Actually we are planning to migrate from our Oracle DB with DR DB in place( on-premises )to GCP cloud PostgreSQL DB .

Do we have any DR DB support features supported in PostgreSQL similar to Oracle Physical standby DB / Data guard like features ?

Any lead will on the above query will be a great help to me to analyze and plan further migration approach, appreciate any quick valuable remarks or comments, Thanks.

2

Hi,

If I’ve understood your question correctly you are looking for a method to automate the various operations that can occur during the life-span of a postgres database system. Since postgres is an RDBMS and nothing more then you’re really talking about its ecosystem and what it can provide.

There are two popular mechanisms, although I am again assuming I understand what you’re asking, that can fill in your needs:

  • Running a postgres cluster within Kubernetes using an operator such as our own Percona Operator.
  • Manage your cluster using Patroni.

In regards to the actual migration: while migrating the data is straightforward as there a number of opensource tools available, the refactoring of sprocs/functions will take up most of your time. As well, if you have created complex reports in Oracle then unless you use commercial proprietary solutions you are looking at refactoring those by hand as well.

Hope this helps

3

Hi Robert,

Greetings !!

Thanks for you quick response, let me reiterate my query once again, please suggest, Thanks

  • Whether DR DB is supported in PostgreSQL for high availability ?
  • If yes, How to setup DR DB in PostgreSQL for high availability with zero data loss?
  • How to migrate Oracle DB with DR DB(On-Premises) in place to PostgreSQL DB (GCP Cloud) ?

Regards,
Das

4

Hi,

Whether DR DB is supported in PostgreSQL for high availability ?

Yes,

How to setup DR DB in PostgreSQL for high availability with zero data loss?

That depends on more factors than can really be covered in this forum. Essentially your asking how to create and manage a cluster.

These links should help you start understanding what you need to consider:

How to migrate Oracle DB with DR DB(On-Premises) in place to PostgreSQL DB (GCP Cloud) ?
This is a very complex subject because you’re not just interested in migrating the data which is actually pretty straightforward but you must also refactor any and all functions, and procedures that have been built into Oracle.

This link covers the various steps and concepts you need to be aware of.

Hope this helps

5

Thanks Robert !!

Regards,
Das