replication slot postgres - manually create replication slot for publication in ... 888slots download

Create a replication slot on your Postgres database to track changes you want to sync. Then, create publication and replication identities for each Postgres table you want to replicate.

Dear community experts, We have 7 dhis2 running on a lxc based installation (postgres 13). We have 256GB Ram. We are very often getting FATAL: remaining connection slots are reserved for non-replication superuser connections these days. We have seen an old post from 2014 around the same topic so we tried max_connections = 1000 in postgres conf, just to test it out, still we get this error very often. Do you have any suggestions on fine-tuning this configuration.

ERROR: could not create replication slot "my_subscription": ERROR: logical decoding requires wal_level >= logical. ... I have done already wal_level to logical and restarted postgresql but error still exists my Postgres is 12.

Query using the following selections: On master node: $ psql postgres=# select * from pg_stat_replication; postgres=# \q.