question on timezone with pgBackRest PITR

From: "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: question on timezone with pgBackRest PITR
Date: 2024-09-20 08:01:34
Message-ID: GV0P278MB0099DBAA231307BBD2AFA1038B6C2@GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The Postgres instance is running on timezone CEST (parameter timezone = 'Europe/Zurich') which is UTC+2.

The underlying Linux OS (K8s container) is running on timezone UTC.

Backups are done with pgBackRest.

With PITR we will have to use target timezone CEST (--target=2024-09-19 17:00:00+02") although OS is running on UTC.

Agreed?

Browse pgsql-general by date

  From Date Subject
Next Message Olleg 2024-09-20 11:32:14 Dependencies on the system view
Previous Message Christophe Pettus 2024-09-20 05:52:32 Re: PgBackRest and WAL archive expiry