PostgreSQL version updates

Reviewed on September 03, 2025

This page lists updates for PostreSQL versions and their corresponding features that are supported at Scaleway.

PostgreSQL 17

Find below the features and updates available with PostgreSQL 17.

The RDB admin role can now assign the following predefined roles:

Role	Description
`pg_maintain`	Allows executing `VACUUM`, `ANALYZE`, `CLUSTER`, `REFRESH MATERIALIZED VIEW`, `REINDEX`, and `LOCK TABLE` on all relations, simulating `MAINTAIN` rights on those objects, even without having it explicitly.

New features are available with PostgreSQL 17:

These are the new advanced settings available with PostgreSQL 17:

Refer to the official Server configuration PostgreSQL documentation for more information.

Find below the new features and updates available with PostgreSQL 16.

The RDB admin role can now assign the following predefined roles:

Role	Description
`pg_read_all_data`	Has the right to read all data as if they have SELECT rights on objects and USAGE rights on schemas, without explicitly having said rights.
`pg_write_all_data`	Has the right to read all data as if they have INSERT, UPDATE and DELETE rights on objects and USAGE rights on schemas, without explicitly having said rights.
`pg_read_all_settings`	Has the right to read all configuration variables.
`pg_read_all_stats`	Has the right to read all `pg_stat_*` views and use statistics related extensions.
`pg_stat_scan_tables`	Has the right to run monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time.
`pg_monitor`	Has the right to read and execute various monitoring views and functions.
`pg_signal_backend`	Has the right to signal another backend to cancel a query or terminate its session.
`pg_checkpoint`	Has the right to execute the CHECKPOINT command.
`pg_create_subscription`	Has the right to issue CREATE SUBSCRIPTION, if they have CREATE permissions on the database.

Tip

Refer to the official Predefined Roles PostgreSQL documentation for a more detailed description of the roles above.

New features are available with PostgreSQL 16:

The logical replication of databases as a subscriber is now supported. Refer to the Setting up logical replication as a subscriber in PostgreSQL documentation page for more information.
Passwords are now encrypted using the SCRAM-SHA-256 setting. If you upgrade your engine and are currently using MD5, you also have to migrate to SCRAM-SHA-256. Refer to the official Password Authentication PostgreSQL documentation to learn how to do so.
Support of the Timescale pre-restore and post-restore features. They allow you to restore the database using pg_restore.