On 3/24/20 9:29 AM, MichaelDBA wrote:
> Can I be added as an editor to the PG WIKI on migrations from Oracle to
> Postgres? I want to add this section:
>
> One special case of Oracle RAC to PG is where they have multiple, separate
> heavy-hitting applications connected to the same RAC Cluster. The mistake is to
> assume that they can simply migrate these applications to point to one PG
> Instance. At this point they miss the big picture of ACTIVE-ACTIVE (Oracle RAC)
> and ACTIVE-PASSIVE (PG). While Oracle can divvy up the applications and load
> balance them across the Nodes in the Cluster, there is no such thing in
> PostgreSQL. Absent some rearchitecture and/or 3rd party tools, it might be wise
> to move the heavy-hitting apps to a one-to-one relationship between APP and PG
> Instance. Regards, Michael Vitale
For the archives -- done
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development