pgpool - connection pooling for postgresql
Translation of the original in Catalan. Read it in: CatalàCastellano
Our ERP access application for mobile phones works with an intermediate database implemented in PostgreSQL and if it keeps growing this way we'll soon need a tool like this one. Basically it's a pooling server for the transactions that arrive from outside against the ODBC interface that the PostgreSQL server publishes. So, here we have the solution: pgpool.
pgpool is a connection pool server for PostgreSQL. pgpool runs between PostgreSQL's clients(front ends) and servers(back ends). A PostgreSQL client can connect to pgpool as if it were a standard PostgreSQL server.
pgpool caches the connection to PostgreSQL server to reduce the overhead to establish the connection to it.
Also, pgpool could use two PostgreSQL servers for fail over. If the first server goes down, pgpool will automatically switch to the secondary server.
Moreover, pgpool supports scheduled switch over.
As you can see, a simple and at the same time very powerful tool.