fly-apps / fly-apps/postgres-flex

Automatic member unregistration fails if primary role cannot be resolved

Open
#79 1 comment 0 reactions 0 assignees View on GitHub
bug documentation flyctl pg:resiliency
Dominant language
Go
Stars
171
Forks
76
Avg merge
1h 19m
Merged PRs (30d)
1

Description

**Example two member setup:**
Member A ( primary )
Member B

**Steps to reproduce**
1. Member B is stopped
2. Member A goes readonly since quorum cannot be met.
3. Member B is removed via flyctl
4. The unregistration process fails, since flyctl cannot find the primary.

**Manual fix**
1. SSH into a running VM
2. `su postgres && cd ~`
3. `repmgr daemon status`
4. `repmgr standby unregister --node-id `

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.