Search code examples
postgresqlc3p0failover

Postgresql with c3p0 - failover

We're using currently c3p0 with postgresql.

Does c3p0 supports any fail-over mechanisms (no info in documentation so I assume that unfortunately no)?

I've found that mysql,oracle and ms sql supports some failover options in jdbc url, e.g. jdbcUrl="jdbc:sqlserver://mainserver:1433;failoverPartner=backupserver;

Are pgpool and pgpool-II only posibilities for postgresql?

Solution

  • I don't know of any built-in failover in either the JDBC driver or the PostgreSQL core

    Other options besides pgpool-II are:

    A complete(?) overview of all solutions is available in the Postgres wiki:

    http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling