Split read/write queries between 2 servers (one master and one slave with streaming replication)?

From: Benjamin Henrion <bh(at)udev(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Split read/write queries between 2 servers (one master and one slave with streaming replication)?
Date: 2012-03-01 22:06:29
Message-ID: CANjd3nfW0_Px0uAPMEXkths3jaD+YuBwbw843mzkdQY-__4obQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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."

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Cornett 2012-03-01 22:30:14 Re: Split read/write queries between 2 servers (one master and one slave with streaming replication)?
Previous Message Lonni J Friedman 2012-03-01 22:01:31 pg_upgrade + streaming replication ?