[SOLVED] How does pg_pool works???

amir86mdu · 08-13-2014, 06:08 AM

Hi All,

I would like to know how does pg_pool works...

In my scenario i have 2 db servers which has to be configured to use pg_pool.

My question is how to configure pg_pool and is it required to configure on both the db servers (both db servers are load balanced and they should replicate and also should act as Master/Slave...

Regards...

TB0ne · 08-13-2014, 03:04 PM

Quote:

Originally Posted by amir86mdu

Hi All,
I would like to know how does pg_pool works...

Then you probably should read the documentation...did you try that?
http://www.pgpool.net/mediawiki/index.php/Main_Page
http://www.pgpool.net/mediawiki/index.php/FAQ

Quote:

In my scenario i have 2 db servers which has to be configured to use pg_pool.

My question is how to configure pg_pool and is it required to configure on both the db servers (both db servers are load balanced and they should replicate and also should act as Master/Slave...

The examples on their website cover setup and installation:
http://www.pgpool.net/docs/latest/pgpool-en.html