Skip to content

Latest commit

 

History

History
92 lines (67 loc) · 4.52 KB

pg-version-updates.mdx

File metadata and controls

92 lines (67 loc) · 4.52 KB
meta content tags dates categories
title description
PostgreSQL version updates
Learn more about the latest updates and features available in each PostgreSQL version at Scaleway
h1 paragraph
PostgreSQL version updates
Stay up-to-date with the latest features and improvements in each PostgreSQL version, and learn how to take advantage of them in your Scaleway Managed Databases
databases postgresql versions updates features
validation
2025-02-24
managed-databases
postgresql-and-mysql

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

PostgreSQL 16

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

Roles

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.
Refer to the official [Predefined Roles](https://www.postgresql.org/docs/16/predefined-roles.html) PostgreSQL documentation for a more detailed description of the roles above.

Features

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.

Extensions

The following extensions were also upgraded.

  • PostGIS - 3.5
  • PG GEOS - 3.13 native with PostGIS 3.5
  • Timescale - 2.17
  • pgRouting - 3.6.2
  • pgvector - 0.8.0
  • H3 PG - 4.1.4

Advanced settings

These are the new advanced settings available with PostgreSQL 16:

Autovaccum

  • autovacuum_vacuum_insert_scale_factor
  • autovacuum_vacuum_insert_threshold
  • autovacuum_vacuum_scale_factor
  • autovacuum_vacuum_threshold

Refer to the official Autovaccum PostgreSQL documentation for more information.

Error reporting and logging

  • cron.timezone
  • log_checkpoints
  • log_lock_waits
  • log_min_duration_statement
  • log_replication_commands
  • log_temp_files

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

PG stats parameters

  • pg_stat_statements.max
  • pg_stat_statements.track
  • pg_stat_statements.track_utility

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