[pgpool-general: 2990] Re: Apps Server configuration ?

[Yugo Nagata]

Hi,

pgpool-II works as like "proxy" of PostgreSQL. This means, pgpool-II
looks like a client from PostgreSQLs and looks like a PostgreSQL server
from your appliction.

[application] <-> [pgpool-II] <-> [PostgreSQL(s)]

So, you don't need to change so many code of your apps. 

However, please note that pgpool-II some restrictions. For example,
pgpool-II cannot process multi-statement queries. 
http://www.pgpool.net/docs/latest/pgpool-en.html#restriction

On Fri, 27 Jun 2014 08:53:01 -0430
Luis Marin <luismarinaray at gmail.com> wrote:

> Hi,
> 
> newbie question:
> 
> As implementer of pgpool, what should I tell to my internal developers
> group, what can we expect from moving our applications from one server with
> apache, postgresql and apps to a pgpool architecture with variable number
> of servers, I'm thinking that 'failover' is a good feature that we could
> benefit, but I'm afraid that they have to change a lot of code, so isn't
> feasible to use pgpool in a very short time, this idea is difficult to
> grasp from me, or I'm wrong and apps does not need any major  changes.
> 
> Any clarifyng idea is welcome
> 
> Thanks


-- 
Yugo Nagata <nagata at sraoss.co.jp>