pg.ddx.io  pgpartman/pg_partman GitHub issues and pull requests  
help / color / mirror / Atom feed
From: dtseiler (@dtseiler) <noreply+dtseiler@github.com>
To: pgpartman/pg_partman <noreply+pgpartman-pg_partman@github.com>
Subject: [pgpartman/pg_partman] discussion #890: Do we need to rename daily/monthly partitions when upgrading from 4.7 to 5+?
Date: Mon, 16 Nov 2026 17:56:17 +0000
Message-ID: <gh-pgpartman-pg_partman-890@github.com> (raw)

I'm (finally) looking to upgrade from 4.7.4 to the current version. My instances are partitioned daily or monthly. One case has a `partition_interval` of `7 days` but it is NOT `1 week`. The partitions all have a `datetime_string` format of `YYYY_MM_DD` (or `YYYY_MM` for monthly).

I re-read [the upgrade doc](https://github.com/pgpartman/pg_partman/blob/development/doc/pg_partman_5.0.1_upgrade.md) and it reads to me like the concern is only for weekly/quarterly partitioned tables. When v5.0.0 was first released, I was under the impression that I would have to rename all of my partitions to from `YYYY_MM_DD` to `YYYYMMDD` (presumably `YYYY_MM` becomes `YYYYMM01`?). Is this not the case or am I really misinterpreting the upgrade docs?

view thread (4+ messages)  latest in thread

Message-ID: <gh-pgpartman-pg_partman-890@github.com>
Permalink:  ../gh-pgpartman-pg_partman-890@github.com/

 · 


This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox