Postgres Replication Slot WAL Size How to re-start it from last point
Postgres Replication Slot WAL Size How to re-start it from last point
On the primary site's database node, start a PostgreSQL console session: sudo gitlab-psql · Find the name of the relevant replication slot · Remove the
Don't drop the group slot Although usually inactive, it's still vital to the proper operation of the EDB Postgres Distributed cluster If you drop it, then The replication slot basically tells Postgres not to recycle or remove any WAL files that could ultimately prevent it from catching up with
slot drain in concrete Replication slots are used to safeguard against the premature deletion of WAL segments before they have been applied by the standby server, thus delete all data on the replica and pull it from the leader): root@my-postgres-0:homepostgres# patronictl reinit my-postgres my-postgres-1