You will want to setup your replication user to connect to PostgreSQL
directly. Going through pgBouncer is asking for trouble.
-Joseph Kregloh
Since you did not specify your O/S and PostgreSQL version, I'll just
point you to the documentation for 9.1.
We're using CentOS 6.5 with PostgreSQL 9.4.1.
Like the original post mentioned, we use a hot standby for replication.
The question is whether we can do the hot standby through pgbouncer
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
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 para
I'm doubtful. Why do you think you need such a capability?
For simplicity. If I can replicate through pgbouncer, I'll need only
one open port on the machine. Postgres would just listen on localhost.
If not, I'll have to make Postgres listen on an interface on a different
port.
-Andomar
On Thursday, May 21, 2015, 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
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 ov