postgres=# select * from pg_replication_slots ;
slot_name | plugin | slot_type | datoid | database
| active | active_pid | xmin | catalog_xmin | restart_lsn
--++---++--+++--+
from your master, can you give us the output of
select * from pg_replication_slots;
maybe some stray slot exists that you may not be aware of ?
Regards,
Vijay
On Mon, Oct 15, 2018 at 1:08 AM Vijaykumar Jain wrote:
> ok my bad.
>
> i just set one of the 9.6.9 versions to have max_replication_
ok my bad.
i just set one of the 9.6.9 versions to have max_replication_slots =2 and
still i had to slots active.
ostgres=# table pg_replication_slots;
slot_name| plugin | slot_type | datoid | database | active
| active_pid | xmin | catalog_xmin | restart_lsn | confirmed_flush_lsn
Am 14.10.2018 um 21:02 schrieb Vijaykumar Jain:
from the doc, it says defaults are 10,
that's only valid for version 10, not for 9.x. Default was 0.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
I guess max_replication_slots has to > current total slots in use. (and
not >= )
https://www.postgresql.org/docs/10/static/runtime-config-replication.html
https://github.com/postgres/postgres/blob/d6e98ebe375e115c29028f9bd090f0f7e07e2527/src/backend/replication/slot.c#L1506
from the doc, it says
