On Thu, Mar 1, 2012 at 5:06 PM, Benjamin Henrion <bh@xxxxxxxx> wrote:
Hi,
I am trying pgpool2 to split read and write queries, where reads
should go to the slave server (streaming replication) and writes to
the master server.
Anybody has a config file that works for pgpool2?
Best,
--
Benjamin Henrion <bhenrion at ffii.org>
FFII Brussels - +32-484-566109 - +32-2-3500762
"In July 2005, after several failed attempts to legalise software
patents in Europe, the patent establishment changed its strategy.
Instead of explicitly seeking to sanction the patentability of
software, they are now seeking to create a central European patent
court, which would establish and enforce patentability rules in their
favor, without any possibility of correction by competing courts or
democratically elected legislators."
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I've attached my pgpool conf.
All pgpool is doing here is the load balancing, replication is handled by streaming replication (9.0+)
PGPool can be setup to do auto failover as well, although that isn't shown in the attached config.
I'm sure some pgpool people will jump on and let me know how I'm doing it wrong, but this is working quite well in production for us.
-Adam
Attachment:
pgpool.conf
Description: Binary data
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
