Getting error while running the pg_basebackup through PGBOUNCER

[raghavendrajsv]

We are using PGBOUNCER(connection pool mechanisam). PGBOUNCER uses port 5433.

Postgres database port number is 6433. By using port 5433 PGBOUNCER is connecting to postgres port 6433 database.

Now PGBOUNCER is establishing the connections properly but when I try to run the pg_basebackup through port 5433(PGBOUNCER port) we are receiving below error. Please guide me.

/opt/postgres/9.2/bin/pg_basebackup -p 5433 -U postgres -P -v -x --format=tar --gzip --compress=1 --pgdata=- -D /opt/rao

pg_basebackup: could not connect to server: ERROR: Unsupported startup parameter: replication

[Melkij]

Why you want use connection pool for replication protocol?

[raghavendrajsv]

The ‘pg_basebackup’ makes a replication protocol connection (just like a replication client) to the PostgreSQL server indirectly. We are using pgbouncer for connection pool mechanisam only.

…

On Mon, 8 Apr 2019 at 19:31, Melkij ***@***.***> wrote: Why you want use connection pool for replication protocol? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#382 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/Afs31x2SD_NOS-V9FoMLH9hVN-_jTcSkks5ve0uugaJpZM4ciQIe> .

-- Regards, Raghavendra Rao J S V Mobile- 8861161425

[cbandy]

What is the value of your ignore_startup_parameters?

[petere]

Replication connections through PgBouncer are not supported. I'm not sure if there is any sense in supporting that.