# DR DB support features supported in PostgreSQL **URL:** \ **Category:** PostgreSQL\ **Created:** [May 16, 2024, 9:20am UTC](https://forums.percona.com/t/dr-db-support-features-supported-in-postgresql/30352 "2024-05-16T09:20:28Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Satyajit\_Das](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/satyajit_das/32/15629_2.png) [@Satyajit\_Das](https://forums.percona.com/u/Satyajit_Das)\ **Post date:** [May 16, 2024, 9:20am UTC](https://forums.percona.com/t/dr-db-support-features-supported-in-postgresql/30352/1 "2024-05-16T09:20:28Z")
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. ---
**Author:** ![Robert\_Bernier](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/robert_bernier/32/1367_2.png) [@Robert\_Bernier](https://forums.percona.com/u/Robert_Bernier)\ **Post date:** [May 16, 2024, 1:06pm UTC](https://forums.percona.com/t/dr-db-support-features-supported-in-postgresql/30352/2 "2024-05-16T13:06:33Z")
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](https://docs.percona.com/percona-operator-for-postgresql/2.0/index.html). - Manage your cluster using [Patroni](https://docs.percona.com/postgresql/16/solutions/high-availability.html). 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 ---
**Author:** ![Satyajit\_Das](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/satyajit_das/32/15629_2.png) [@Satyajit\_Das](https://forums.percona.com/u/Satyajit_Das)\ **Post date:** [May 17, 2024, 4:54am UTC](https://forums.percona.com/t/dr-db-support-features-supported-in-postgresql/30352/3 "2024-05-17T04:54:14Z")
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 ---
**Author:** ![Robert\_Bernier](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/robert_bernier/32/1367_2.png) [@Robert\_Bernier](https://forums.percona.com/u/Robert_Bernier)\ **Post date:** [May 20, 2024, 1:46pm UTC](https://forums.percona.com/t/dr-db-support-features-supported-in-postgresql/30352/4 "2024-05-20T13:46:03Z")
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: - [High availability - Percona Distribution for PostgreSQL](https://docs.percona.com/postgresql/16/solutions/high-availability.html) - [PostgreSQL HA with Patroni: Your Turn to Test Failure Scenarios](https://www.percona.com/blog/postgresql-ha-with-patroni-your-turn-to-test-failure-scenarios/) - [Backup and Recovery for Databases: What You Should Know](https://www.percona.com/blog/backup-and-recovery-for-databases-what-you-should-know/) - [Backup and disaster recovery - Percona Distribution for PostgreSQL](https://docs.percona.com/postgresql/14/solutions/backup-recovery.html) - [Deploy a standby cluster for Disaster Recovery - Percona Operator for PostgreSQL](https://docs.percona.com/percona-operator-for-postgresql/2.0/standby.html) - [White Papers - Percona](https://www.percona.com/resources/white-papers) - [PostgreSQL: Disaster Recovery - Percona](https://www.percona.com/resources/postgresql-disaster-recovery) > 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. - [https://www.youtube.com/watch?v=MBw08uYxTlk](https://www.youtube.com/watch?v=MBw08uYxTlk) Hope this helps ---
**Author:** ![Satyajit\_Das](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/satyajit_das/32/15629_2.png) [@Satyajit\_Das](https://forums.percona.com/u/Satyajit_Das)\ **Post date:** [May 22, 2024, 3:59am UTC](https://forums.percona.com/t/dr-db-support-features-supported-in-postgresql/30352/5 "2024-05-22T03:59:37Z")
Thanks Robert !! Regards, Das