Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Replication issues #48

Open
Tracked by #56
Lun4m opened this issue Jan 6, 2025 · 0 comments
Open
Tracked by #56

Replication issues #48

Lun4m opened this issue Jan 6, 2025 · 0 comments

Comments

@Lun4m
Copy link
Collaborator

Lun4m commented Jan 6, 2025

While performing the migrations, the standby node somehow got detached from the primary node.
Unfortunately this in turn blocks ingestion to the primary, since it keeps waiting for the standby to come back up (we are using synchronous replication).
I tried running repmgr standby follow, but it complains with "standby node not found in 'pg_stat_replication'".
The "quick" workaround I found was to run the following:

repmgr standby unregister
sudo systemctl stop postgresql
repmgr standby clone -h <primary_ip> -U repmgr -d repmgr -F
sudo systemctl start postgresql
repmgr standby register

but this is not ideal since all the data needs to be copied from scratch.

Anyway, I'm not sure why the standby stopped working in the first place. Maybe we should use replication slots, modify the WAL options, or use Barman.

We should also implement a way to detect when a node goes down, be it primary or standby.

@intarga intarga mentioned this issue Jan 7, 2025
9 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant