Re: Replicate over pgbouncer?

From: Melvin Davidson <melvin6925(at)gmail(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Andomar <andomar(at)aule(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Replicate over pgbouncer?
Date: 2015-05-21 18:11:33
Message-ID: CANu8FiyYKrLBrYpKcGjMMhazkhPK6qNkbznU11FqrakRpV1bfg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Since you did not specify your O/S and PostgreSQL version, I'll just point
you to the documentation for 9.1.

http://www.postgresql.org/docs/9.1/interactive/different-replication-solutions.html

It looks very much to me like you are trying to use a hammer to turn a
screw. pg_bouncer is not designed for replication. I strongly suggest you
review the url provided and pick the method that best suits your needs.

On Thu, May 21, 2015 at 2:00 PM, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:

> On 5/21/15 12:12 PM, Andomar wrote:
> > Hi,
> >
> > Today I installed pgbouncer. I added a second installation as a hot
> > standby. Before starting the standby, I configured "recovery.conf" to
> > connect to pgbouncer.
> >
> > This results in an error message:
> >
> > Pooler Error: Unsupported startup parameter: replication
> >
> > Is it possible to replicate over a connection through pgbouncer?
>
> Currently not.
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andomar 2015-05-21 18:35:43 Re: Replicate over pgbouncer?
Previous Message Brown, Joseph E. 2015-05-21 18:04:37 Re: Allowing postgresql to accept 0xff syntax for data types that it makes sense for?