Has anyone used the PostgreSQL 9.2 Database Cluster feature and had CA APM/CEM connected to a PostgreSQL cluster (one database, multiple hosts)
PostgreSQL: Documentation: 9.2: Creating a Database Cluster
Found references to High Availability, Load Balancing and Replication
PostgreSQL: Documentation: 9.2: High Availability, Load Balancing, and Replication
25.1 Comparison of Different Solutions
So there seems to be some functionality within the Postgresql 9.2 version but the question is, has anyone attempted, was successful/failed and what issues or discoveries did you make during your travels down this path?
Fail Over - Protect the MoM, the Collectors can deal
Hi We are also looking at this and have enabled EM failover and looking to configure postgres as a hot standby - is this a supported solution ?
As it stands with the EM in hot standby when the primary EM stops the secondary EM takes over - but in the case where you lose the whole server - would the secondary EM know to connect to the secondary postgres db ?
I think you can make a postgres HA and configure DNS server for EMs to point to the second postgres in case of failover but this is not a supported solution. We support Oracle RAC as APM DB and it has the failover mechanism. So, Oracle RAC seems to be an alternative approach.
Thank you Mukesh Singh.
Is the Oracle RAC as APM DB for fail over tested, certified and supported by CA?
This is part of the larger question on APM fail over.