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

2018-02-14 Thread Pierre Timmermans
Thanks. Indeed pgBouncer is the usual candidate in front of postgres streaming replication, together with pgpool. Take care that your link on pgBouncer dates back from 2008 !.  I had a look at pgBouncer in the past, but it was not actively maintained at that time. So I settled on a combination o

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

2018-02-14 Thread Melvin Davidson
On Wed, Feb 14, 2018 at 2:27 PM, Pierre Timmermans wrote: > pgpool does just that: it enables you to use the standby database as a > read only while other queries are sent to the primary database only ( > http://www.pgpool.net/). Good product and good support (on the list° > > This looks a very i

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

2018-02-14 Thread Pierre Timmermans
pgpool does just that: it enables you to use the standby database as a read only while other queries are sent to the primary database only (http://www.pgpool.net/). Good product and good support (on the list° This looks a very interesting possibility, although it is more related to automated fai

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

2018-02-14 Thread Venkateswaran
Hi, I am also trying to split read and write queries, where reads should go to the slave server (streaming replication) and writes to the master server. Any tool available to perform this activity instead of two connection pool? -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general