Home > mailing lists

question on timezone with pgBackRest PITR - Mailing list pgsql-general

From	Zwettler Markus (OIZ)
Subject	question on timezone with pgBackRest PITR
Date	September 20 14:01:34
Msg-id	GV0P278MB0099DBAA231307BBD2AFA1038B6C2@GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM Whole thread Raw
List	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?

From: Christophe Pettus
Date: 20 September, 11:52:32
Subject: Re: PgBackRest and WAL archive expiry

From: Olleg
Date: 20 September, 17:32:14
Subject: Dependencies on the system view