pg_partman 5.0.0-beta available for community testing

From: Crunchy Data via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: pg_partman 5.0.0-beta available for community testing
Date: 2023-08-17 07:13:53
Message-ID: 169225643340.642.17544925473862911250@wrigleys.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-announce

Crunchy Data is proud to announce the upcoming release of pg_partman 5.0.0. We are currently releasing a beta version for community testing.

### Highlights of this release

Version 5.0.0-beta August 16th, 2023

- pg_partman is deprecating many older features. These are breaking changes, so please proceed with caution on updates
- Removing trigger-based partitioning
- Special time-based intervals are removed
- A minimum version of PostgreSQL 14 is required
- The default table is optional
- Simplified partitioning suffixes

The top of the update file contains the current [full release notes](https://github.com/pgpartman/pg_partman/blob/5.0.0-beta/updates/pg_partman--4.7.3--5.0.0-beta.sql).

Since this is a beta release, this version cannot be installed directly. The standard installation procedures will install the latest stable release (4.7.3) into the database. To install 5.0.0-beta, you will then have to run an extension update

```
ALTER EXTENSION pg_partman UPDATE TO '5.0.0-beta’;
```

There will also not be any upgrade paths from 5.0.0-beta to the final 5.0.0. So please do not install this for production use.

Special instructions for certain upgrade scenarios can be found in the [5.0.0 upgrade guide](https://github.com/pgpartman/pg_partman/blob/5.0.0-beta/doc/pg_partman_5.0.0_upgrade.md). General usage instructions and other guides can be found in the [documents folder](https://github.com/pgpartman/pg_partman/blob/5.0.0-beta/README.md#documentation) of the 5.0.0-beta branch.


### About pg_partman
[https://github.com/pgpartman/pg_partman](https://github.com/pgpartman/pg_partman)

pg_partman is an extension to create and manage both time-based and number-based table partition sets. As of version 5.0.0, only built-in, declarative partitioning is supported and the older trigger-based methods have been deprecated.

The declarative partitioning built into PostgreSQL provides the commands to create a partitioned table and its children, but it does not provide a means of automating that child table maintenance over time (Ex. adding new children, dropping old ones based on a retention policy). It also does not provide a means to easily turn an existing table into a partitioned table or vice versa. pg_partman aims to use the built-in declarative features that PostgreSQL provides, but build upon them to provide those missing features as well as many others to help make managing partitions easier.

**Thank you in advance for helping with the testing of pg_partman’s upcoming release. Please submit [issues](https://github.com/pgpartman/pg_partman/issues) or [pull requests](https://github.com/pgpartman/pg_partman/pulls) for anything you find. General questions can be submitted to [discussions](https://github.com/pgpartman/pg_partman/discussions).**

Browse pgsql-announce by date

  From Date Subject
Next Message SCaLE Conference via PostgreSQL Announce 2023-08-17 07:15:45 CfP is open for PostgreSQL@SCaLE
Previous Message PostgreSQL Europe via PostgreSQL Announce 2023-08-14 02:05:15 Schedule published for PGDay UK 2023, September 12th, London, England