From: jw1u1 (@jw1u1) <noreply+jw1u1@github.com>
To: pgpartman/pg_partman <noreply+pgpartman-pg_partman@github.com>
Subject: Re: [pgpartman/pg_partman] issue #865: inconsistent timezone handling in case of retention
Date: Thu, 15 Oct 2026 10:30:08 +0000
Message-ID: <gh-pgpartman-pg_partman-865-c6189984022@github.com> (raw)
In-Reply-To: <gh-pgpartman-pg_partman-865@github.com>
References: <gh-pgpartman-pg_partman-865@github.com>
The inconsistent timezone handling does affect all types of maintenance.
Different client timezone settings are a frequent source of errors.
To make pg-partman more fault-tolerant, i would propose an additional parameter maintenance_timezone in the part_config, defaulting to the server timezone setting.
This timezone should be set in all maintenance functions.