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?