Can we have Pega Development environment in Cloud with PostgreSQL as the database and then in the higher and PROD environments we will have Oracle as the database. Is this implementation possible in PEGA. Please suggest.
At the offering level, we do not support this architecture currently because of the below reason.
It's not an optimal solution because if you want to test something to implement in production and / or any higher environment, we always prefer testing it in lower env with similar config (scaled down) and then implement in higher env. With lower and higher envs working with different types of DBs, it's very hard to do such things, especially when we run into issues and want to implement some solution at DB level.
Simply put, we do not offer it because it's not logical to have such implementation.
Hope this helps. However, if there is any specific reason or use case for which you want such an architecture, please share it with us and we can always think about new things :)
It is TECHNICALLY possible as PegaCloud Legacy runs on Oracle and Pegacloud 2.x runs on Postgres. We have expertise in both areas and can say they are both robust platforms for PRPC. Our implementations are either Oracle or Postgres and are never mixed.
It is NOT RECOMMENDED for the reasons Ankur brought up. It is a Best Practice to keep your environments the same to avoid any potential issues with functionality, performance and vendor (licensing, support, etc.) issues between them.
In my opinion, the most important part of a PRPC implementation is the database. All the code you develop and data you use are kept there. Your choice of database platform is very important. My advice to to choose one and stay with it.
If you are doing this in your own cloud then you could have PG in DEV and Oracle in Prod. However, there is an enormous risk that an app that works fine in DEV will have problems (or not work at all) after it is moved PROD. Hence, it is indeed possible but absolutely NOT recommended by PEGA. If you do want to mix the two DB solutions, you do so at your own risk.
If you are purchasing the "PRPC on PegaCloud" product then "mixing" is NOT an option. New PegaCloud environments are created with Postgres as the (only) DB solution. We do not recommend "mixing" DB vendors and do not do this in our PegaCloud product.