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