Support Policies for RHEL High Availability Clusters - Management of a PostgreSQL Database in a Cluster

Updated

Contents

Overview

Applicable Environments

  • Red Hat Enterprise Linux (RHEL) with the High Availability Add-On

Useful References and Guides

Introduction

This guide offers Red Hat's policies and requirements around managing PostgreSQL databases with a RHEL High Availability cluster. Users of RHEL High Availability clusters should adhere to these policies in order to be eligible for support from Red Hat with the appropriate product support subscriptions.

Policies

Scope of Red Hat support with PostgreSQL resources managed by a cluster: Refer to Red Hat's policy on Management of applications that Red Hat does not ship for further details on Red Hat's scope of support applicable to PostgreSQL software deployments in a RHEL High Availability cluster.

The focus of Red Hat's assistance may be limited to functionality of the High Availability software and the pgsql agent. In some cases your PostgreSQL DBA's input may be necessary to diagnose the nature of a problem - even if the problem originates in the resource agent Red Hat ships. Solutions to problems with RHEL High Availability + PostgreSQL deployments may be dependent upon some input or deliverable from the PostgreSQL maintainers in cases where the issue can not be solved adequately through RHEL High Availability without the PostgreSQL maintainers' assistance.

Currently, only default RHEL versions of the postgresql-server package are supported with the ocf:heartbeat:pgsql resource agent in any OS release. Support for additional versions provided by Red Hat Software Collections (SCL) may be added later. Third-party PostgreSQL installations are not supported and cannot be guaranteed to work with the ocf:heartbeat:pgsql resource agent.

For any combination of OS release and PostgreSQL version not explicitly mentioned below, Red Hat does not support using the pgsql resource agent to manage PostgreSQL. Organizations may choose to implement their own scripts or agents to manage such components, under the condition that such scripts would not be within the scope of Red Hat's support (see general policies on resource management). Customers may also use the pgsql resource agent at their own risk, subject to the same support conditions as custom resource agents.


PostgreSQL 15: Red Hat's support for managing PostgreSQL 15 components in a RHEL High Availability cluster is subject to the following conditions:

  • RHEL 8: Support for PostgreSQL 15 management using the pgsqlresource agent to manage PostgreSQL 15 in a Pacemaker cluster.
  • RHEL 9: Support for PostgreSQL 15 management using the pgsqlresource agent to manage PostgreSQL 15 in a Pacemaker cluster.

PostgreSQL 14: Red Hat does not support PostgreSQL 14 and RHEL High Availability cluster will not support PostgreSQL 14. For more information see: Does Red Hat provide Postgresql 14?


PostgreSQL 13: Red Hat's support for managing PostgreSQL 13 components in a RHEL High Availability cluster is subject to the following conditions:

  • RHEL 9: Red Hat supports using the pgsql resource agent to manage PostgreSQL 13 in a Pacemaker cluster.

PostgreSQL 12: Red Hat's support for managing PostgreSQL 12 components in a RHEL High Availability cluster is subject to the following conditions:

  • RHEL 8: Support for PostgreSQL 12 management using the pgsql resource agent was added with errata RHBA-2021:1736 with the following package(s): resource-agents-4.1.1-90.el8, resource-agents-aliyun-4.1.1-90.el8, resource-agents-gcp-4.1.1-90.el8 or later.

PostgreSQL 10: Red Hat's support for managing PostgreSQL 10 components in a RHEL High Availability cluster is subject to the following conditions:

  • RHEL 8: Red Hat supports using the pgsql resource agent to manage PostgreSQL 10 in a Pacemaker cluster.

PostgreSQL 9: Red Hat's support for managing PostgreSQL 9 components in a RHEL High Availability cluster is subject to the following conditions:

  • RHEL 7: Red Hat supports using the pgsql resource agent to manage PostgreSQL 9 in a Pacemaker cluster.

PostgreSQL 8: Red Hat's support for managing PostgreSQL 8 components in a RHEL High Availability cluster is subject to the following conditions:

  • RHEL 6 with pacemaker: Red Hat supports using the pgsql resource agent to manage PostgreSQL 8 in a Pacemaker cluster.

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.

  • RHEL 8: PostgreSQL 10 is supported.
  • RHEL 9: PostgreSQL 13 is supported.

Scope of Red Hat support with PostgreSQL servers using logical replication: Currently postgres logical replication is unsupported with the resource-agents pgsql or pgsqlms.

SBR
Category
Components
Article Type