Was this page helpful?

PostgreSQL version updates

Reviewed on 24 February 2025

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

PostgreSQL 16Link to this anchor

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.

The following extensions were also upgraded.

These are the new advanced settings available with PostgreSQL 16:

Refer to the official Autovaccum PostgreSQL documentation for more information.

Refer to the official Error reporting and logging PostgreSQL documentation for more information.

Refer to the official PG stats parameters PostgreSQL documentation for more information.

Was this page helpful?