Bug 2092035

Summary: Add support for logical replication for pgsql resource agent
Product: Red Hat Enterprise Linux 8 Reporter: Josef Zimek <pzimek>
Component: resource-agentsAssignee: Oyvind Albrigtsen <oalbrigt>
Status: ASSIGNED --- QA Contact: cluster-qe <cluster-qe>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 8.4CC: agk, cfeist, cluster-maint, fdinitto, sbradley
Target Milestone: rc   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Josef Zimek 2022-05-31 15:04:53 UTC 
Description of problem:

Postgres database supports streaming and logical replication modes [1]. While Red Hat specifically mentions streaming is supported the logical replication seems uncovered.

Support Policies for RHEL High Availability Clusters - Management of a PostgreSQL Database in a Cluster 
https://access.redhat.com/solutions/3618691 :

"Scope of Red Hat support with PostgreSQL servers using streaming replication: The same policies that applies to the pgsql resource-agent applies to the pgsqlms resource-agent. Currently only PostgreSQL 10 is supported.:



Version-Release number of selected component (if applicable):
All

How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

[1] https://www.postgresql.org/docs/12/logical-replication.html