pgpool slony slaves only

From: Frank Jansen <fjansen(at)heimstar(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: pgpool slony slaves only
Date: 2010-12-07 17:11:05
Message-ID: 4CFE6AA9.30509@heimstar.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

as the Subject says i want pgpool to talk only to my slony slaves.
In my company we have a Slony Setup with 1 master replicating to 2
slaves. Our application only does read queries (never ever writes) to
the 2 slaves through pgpool. While upgrading to pgpool 3.0.1 (from
2.2.5) i detected that the former admin has set up pgpool with
replication_mode on. I now thought about going to master_salve_mode ,
but i am bit lost between the various possibilities of modes, especially
cause i dont need any write queries deleivered to my slony master. cause
the application we run will just read and never write. We want just
connection pooling and load balacing through pgpool to our 2 slaves.

Couldnt find anyone on google using pgpool to access read only his slony
slaves, maybe someone has suggestions for me.

Regards,

Frank Jansen

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2010-12-07 17:27:10 Re: Type cast removal - proposed exceptions for xml,enum
Previous Message Kobi Biton 2010-12-07 16:58:46 Re: *****SPAM***** Re: if-clause to an exiting statement