ClusterLabs / ClusterLabs/resource-agents

pgsql RA pgsql-data-status could be 'STREAMING|QUORUM‘

Open
#1,275 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Shell
Stars
519
Forks
608
Avg merge
6d 1h
Merged PRs (30d)
7

Description

New in PG10, sync_state field of pg_stat_replication could be 'quorum', but the latest pgsql RA doesn't
considers this situation.
When the rep-mode is ‘async', pgsql-data-status maybe 'STREAMING|QUORUM', so the standby pg won't be promoted anyway.

https://www.postgresql.org/docs/10/monitoring-stats.html

Contributor guide

No contributing guide indexed for this repository

Research direction

Locate the pgsql resource agent entry point and the logic that derives pgsql-data-status from PostgreSQL replication state. Read the PostgreSQL 10 pg_stat_replication documentation and trace how async rep-mode handles sync_state. Done means quorum state is represented in the status and a quorum standby is not promoted incorrectly.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, shell
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.