Managing PostgreSQL versions

RayDB allows users to select and manage their PostgreSQL version when deploying clusters. Keeping your PostgreSQL version up to date ensures security, stability, and access to new features.

Selecting a PostgreSQL Version

• When creating a new cluster, you can choose the PostgreSQL version from the Cluster Creation page.
• The available versions are displayed based on supported releases.
• It is recommended to select the latest stable version for long-term support.

Checking Your Current PostgreSQL Version

To verify the version of your cluster:

SELECT version();

Alternatively, you can check the version in the Cluster Details section of the RayDB Dashboard.

Upgrading PostgreSQL

Minor Version Upgrades

• Minor upgrades (e.g., 15.2 → 15.3) include security patches and bug fixes.
• These can be performed automatically or manually in the dashboard.
• Automatic Upgrades: Enabled by default and applied during maintenance windows.
• Manual Upgrades:
  1. Log in to the RayDB Dashboard.
  2. Navigate to Cluster Settings → Maintenance.
  3. Click Upgrade Now to apply the latest minor version.

Major Version Upgrades

• Major upgrades (e.g., 14.x → 15.x) require data migration.
• Direct in-place major upgrades are not supported.
• To upgrade:
  1. Create a new cluster with the desired PostgreSQL version.
  2. Use pg_dump and pg_restore to migrate data.
  3. Update your application to connect to the new cluster.

Best Practices

• Enable automatic minor upgrades to ensure security patches are applied.
• Test major upgrades in a staging environment before migrating production data.
• Monitor PostgreSQL release notes for compatibility and feature changes.

For details on performing backups before upgrading, see Backups and Restores.