hapostgres / hapostgres/pg_auto_failover

New secondary node remains in a "down" status after a switchover. This occurs when different certificate names are used on the primary and secondary nodes.

Open
#1,089 1 comment 1 reaction 0 assignees View on GitHub
Dominant language
C
Stars
1.4k
Forks
142
Avg merge
5h 8m
Merged PRs (30d)
1

Description

We've encountered an issue when using different certificates or certificate paths on primary and secondary nodes with `postgresql-auto-failover.conf`.

When the `postgresql-auto-failover.conf` files are generated, they include the specific certificate path and name. During a switchover, `pg_auto_failover` uses `pg_rewind` to synchronize data between the primary and secondary nodes. In this process, `pg_rewind` updates the `postgresql-auto-failover.conf` file of the former primary node to match that of the new primary.

This creates a problem because the former primary node then expects a different certificate or certificate path than what it actually has. As a result, it remains in a down state because it cannot locate its certificate.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.