pg.ddx.io  pgpartman/pg_partman GitHub issues and pull requests  
help / color / mirror / Atom feed
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.

view thread (2+ messages)

Message-ID: <gh-pgpartman-pg_partman-865-c6189984022@github.com>
Permalink:  ../gh-pgpartman-pg_partman-865-c6189984022@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