Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1srYaJ-002ib4-N2
	for pgsql-general@arkaria.postgresql.org; Fri, 20 Sep 2024 08:01:49 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1srYaH-000aVC-8o
	for pgsql-general@arkaria.postgresql.org; Fri, 20 Sep 2024 08:01:46 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <Markus.Zwettler@zuerich.ch>)
	id 1srYaG-000aUy-NA
	for pgsql-general@lists.postgresql.org; Fri, 20 Sep 2024 08:01:46 +0000
Received: from mx4.stadt-zuerich.ch ([194.56.33.13])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <Markus.Zwettler@zuerich.ch>)
	id 1srYaD-0009MV-Oa
	for pgsql-general@lists.postgresql.org; Fri, 20 Sep 2024 08:01:45 +0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
  d=zuerich.ch; i=@zuerich.ch; l=7459; q=dns/txt;
  s=zuerichch202311; t=1726819303; x=1758355303;
  h=from:to:subject:date:message-id:mime-version;
  bh=Pgh4zSyJEdGhzhVP++SR8pK1cnoUriDvSDmpW6PhKL4=;
  b=lsTTwAlLduXxs1aym55U3mCZx9gjj54L0iXnz3NDmtnK6g/tSQTRKxgs
   SLcaPKtJkTAlu0ane7RLzVN0zu5eXLA+zn7KQWusfG1xFsbzVfMXKIKS5
   pujI7lGk0x5UlRLdVz61JT/B5Bc+nW8urYBfStEjkO9D+0M/6ns+ezz76
   sGv0xWHkjM2gLhFejKHVuTguIArvjK89ExGxiTVU74wY9Sf+x7ud+3/Cu
   Io7cnBmqSs0bX5mSCtCKFnusZfbzf+RZMf1aw5+FmO15sFFSUKG359vpa
   OktPZb8UXBcuQ0jV2wk5tTCRa0K9f9d7SrlrN1UkfUeHf60VIeCEwS0ZS
   A==;
X-CSE-ConnectionGUID: t97NJa8rScefDc+BOjoqYw==
X-CSE-MsgGUID: ooo7qhI8SauYBs0G0Z8Vmg==
X-IronPort-AV: E=Sophos;i="6.10,243,1719871200"; 
   d="scan'208,217";a="62603035"
Received: from unknown (HELO szhm35325.global.szh.loc) ([10.34.130.221])
  by mx4.prm.szh.zone with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 20 Sep 2024 10:01:42 +0200
Received: from szhm35325.global.szh.loc (10.34.130.221) by
 szhm35325.global.szh.loc (10.34.130.221) with Microsoft SMTP Server
 (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id
 15.2.1544.11; Fri, 20 Sep 2024 10:01:40 +0200
Received: from ZRAP278CU002.outbound.protection.outlook.com (10.7.48.75) by
 szhm35325.global.szh.loc (10.34.130.221) with Microsoft SMTP Server
 (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id
 15.2.1544.11 via Frontend Transport; Fri, 20 Sep 2024 10:01:40 +0200
ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none;
 b=ccUa/otcC6SQFEyu1Tu6EHqaNhGI+Oi/2YRoeEfUpe2765cSL9SiK1T1ROgvmdFbs5jCQEiiEC8b2RvBVDEZbil+TdSulfnTyf4vrh8kg9kswA38EhiPGKcLf7TZxAZ/9Vv6ZfUZT6O2xlpEaSTPbT5vsBuz/ItfU2m1f4BydDcClMN1wX3468e77lKd1zwFH3yD4JldLSJJ2ArUPBPhFVDLcbRtJIudSYCqiWFYv7G14iaG8fhfS/YlGe9m4eTiREf3HCmN3ZtUvHc9G4qXrBLLsccv7JcBxAwnlaltBv3LjhnJHhWTbW2cXymsmNRgK2PDKtRmL/GnQJXAIkRNhQ==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com;
 s=arcselector10001;
 h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1;
 bh=Pgh4zSyJEdGhzhVP++SR8pK1cnoUriDvSDmpW6PhKL4=;
 b=XTMhgd0L109nC+ib9TOuIi0jiFXqMq32uSvWfeME0yFnrGYYrBWFiT1piT/1sftrpt6xu1nINpGO1u3Vvkvn5n+I8WwyV8PIljOpFavRFbOdRjvKKPWmrU42bVhSgRXVb/I0wMUymI3FnwKisu1P3b8xxedCeZWiFioWC/mJAFsZKzIA+m/9zJc5VWsZhz1Y9egrqwayc5Z+kASKazmq8SfAsCOG4hhGVnOZY5zb0vmGH6YpfRDVp8AFgl/SA3sFeQYN+EhAwUUwlZkZP2IL1ZkCfdxPp0oEeGYAwl3h7pO2qeAxw6pBNzX+oB9owZS5d8JLHl4z4imryvVW+1pmKQ==
ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass
 smtp.mailfrom=zuerich.ch; dmarc=pass action=none header.from=zuerich.ch;
 dkim=pass header.d=zuerich.ch; arc=none
Received: from GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM (2603:10a6:710:27::12)
 by ZRAP278MB0826.CHEP278.PROD.OUTLOOK.COM (2603:10a6:910:49::13) with
 Microsoft SMTP Server (version=TLS1_2,
 cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7982.19; Fri, 20 Sep
 2024 08:01:34 +0000
Received: from GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM
 ([fe80::bf73:d490:294c:3df3]) by GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM
 ([fe80::bf73:d490:294c:3df3%5]) with mapi id 15.20.7982.018; Fri, 20 Sep 2024
 08:01:34 +0000
From: "Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>
To: pgsql-general <pgsql-general@lists.postgresql.org>
Subject: question on timezone with pgBackRest PITR
Thread-Topic: question on timezone with pgBackRest PITR
Thread-Index: AdsLMfHL0gDDQETOSjSD665RqStbog==
Date: Fri, 20 Sep 2024 08:01:34 +0000
Message-ID: <GV0P278MB0099DBAA231307BBD2AFA1038B6C2@GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM>
Accept-Language: de-DE, en-US
Content-Language: de-DE
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=zuerich.ch;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: GV0P278MB0099:EE_|ZRAP278MB0826:EE_
x-ms-office365-filtering-correlation-id: 2ba71685-014c-4d1d-aee5-08dcd94a71fd
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;ARA:13230040|376014|366016|1800799024|38070700018;
x-microsoft-antispam-message-info: =?us-ascii?Q?9KrcdeyyURnDQt9nDNKOKMJnOjmIJS0XBCy2AO0VmfHR3MlgwBsi/FrR8duk?=
 =?us-ascii?Q?XmVIkhxsvMPvkbbxHecpmG63q13inA20BMISxIxttCa44zYiFls+IhpGJFbo?=
 =?us-ascii?Q?/CaShBtkzRqZB2bmn/keN+U/e1/TVvgN07+242QOeNMW7S9j4eLEgY70QgI5?=
 =?us-ascii?Q?FLjomREACftUkQTRJxnEFX+VZSyhisGau39XsFfyh3owB3/W8EjmYFlphuP6?=
 =?us-ascii?Q?KpixLqirPEKA1yt7KW1LQDFZoyIjCvUSfPOjnxTjVP6HXwpteyaMQp9RxVt2?=
 =?us-ascii?Q?doIYJc/vN//98+fUnjKGSbRUT8H3zOWJxvG6cw6fcSsp7cCFFI+3rb+TC5AG?=
 =?us-ascii?Q?5AdsnUUlA8UoN4I+jLdxMEFwuQWHdWcHBrTTH5Svnt0aAYgPJdy5gclJEJr5?=
 =?us-ascii?Q?hReWVdUTjSCVkWmgfxoa+rc+wFnzFPwFtFbGn5O468675w3q+du0+uvkuiu2?=
 =?us-ascii?Q?tY/hu+ScaI+5M1gHzx8gbG0qDyaZcdFwPedvFY+ViD4lDpEOi1xq5pKwxY+q?=
 =?us-ascii?Q?OEc/J1tBWQqQJ38n5qocyDJ3dOjtbXy0mTAyBEla+xCeUm/XvJ9gt7xajOSy?=
 =?us-ascii?Q?6I7TDqbWyE/jO/VrCgZG9pKVBKOQAa1vVWlSovBDDYSxbjYQ0D/jwcf1DCYD?=
 =?us-ascii?Q?6Jx35toNx5f1JO48g+kCk1fqJaRqftdsoXSpnpU1PWpc0WmuHK3n5eS7J0F9?=
 =?us-ascii?Q?ASxh69rVMQzUChrftDNvLDO6twaLPAR8Mtx6aPxVlD9PJjVhDNyAxzZvcrYB?=
 =?us-ascii?Q?WR110ZeP7K4xVwAiyJ43AC9Gkk8kIULwYXDSvPIs7ko2VyUJMLKiTmyNzRPO?=
 =?us-ascii?Q?HANOsASE1sYZcRImxoHqlfJHqhKy3rjjckB4dT0xgsi/gSzQ/NsSm6Fi6Gvb?=
 =?us-ascii?Q?nwZzbMb43zOy8FP0OXay+NYz6cf3LGbamDJDHOb2FB7ciAGkATkZDhblV/L5?=
 =?us-ascii?Q?W+JVFtbl3hxthPiEKhTCzunujcNaZODDy/EXpmwyWl/qVa4OYg/qrhuMEnqf?=
 =?us-ascii?Q?yZMln6FSYyiYx01bKGKSoBV0x5I5tsOSPrYpOj0Vw5ivZ0QgIO72BZqy47IO?=
 =?us-ascii?Q?+3XobpjPuomxghuIOfEnnu7UXfiPcUw9JOOxpYKhJj9QwNQExU4Or4JVCFnA?=
 =?us-ascii?Q?tOSth2rhDJ/JVxpOCmRTALZXWUhQHYApn18VO055oE7OSHrcBUYgS5UEVSDu?=
 =?us-ascii?Q?m/QrHyiBlpgMf19dENTRIKWpdKNwb0J6bQjzuqlTVGkzHpCAFpBLoB9q/TQp?=
 =?us-ascii?Q?AHzLwTfqq1bTIfsM4+jVC+1CBuP0Rb14TfvcQHx5bnefWmjqOsWjXTr1Tb6N?=
 =?us-ascii?Q?OT2+aZJOxSloCN7MTbwWlbhF9eTeR13f79DzxKxCogVzZ1EyveJm61u1/T/J?=
 =?us-ascii?Q?CPbZ6nFgSZDdAfAdv8x3R84Ro6q4D6lmjdcsfvYEQIKE3IvQjw=3D=3D?=
x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(376014)(366016)(1800799024)(38070700018);DIR:OUT;SFP:1101;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?+IKjdADbNFLliZX9+a6sqstjzMlnUjpoU5jNf4rIcMS7UoVqFXlrv34k8hPp?=
 =?us-ascii?Q?v+wBX2qgDCXtw0zvFixBDD2PHftNQEfusS+7V7X3hYwv+XZtlFwbhF1SMvaV?=
 =?us-ascii?Q?9tZYsOs5VCHhl7lh4vJwmPQDedeMAfJ9ufaH11XQb1u1I20ouSvIZNAgdeWX?=
 =?us-ascii?Q?Jk2fguo/fhHyQInisX5hIckjtEMEZg9q8xde+TZKAbdUT9n2a3j++dzmGggC?=
 =?us-ascii?Q?PbE/jSff1hQcSIshwWb32vTLIQn55NmTu4GQeZxmssFcmK4v1CvFBljHRRPp?=
 =?us-ascii?Q?2vGjFBYJ4sPiiwOlOMlCQDQhxTX6xc/Vi+qlcKG9/OBdS21TAJ7PYTknwd9Q?=
 =?us-ascii?Q?hslFRruX7W3P6d02iRBHI3az7K3YT6uU1VfZ7PDHhdudWs+YMmWBggXAeXND?=
 =?us-ascii?Q?mcO4rFS9iqPvp8sTyOEVCaABMChEiEbFQ/OENZfi7QEgOwCbroJFw+ZLg1v/?=
 =?us-ascii?Q?mglULuupRb6qLpfyAYR6T0fsGXx3YIFQuiol5ET2FR4yMMvitib4NeZi1CkE?=
 =?us-ascii?Q?4q+zGXuBUe541H+WeOgxREV5tqNGl/tlO4gtX9gw2jrGwg2FG4y8Gi1uy+Ke?=
 =?us-ascii?Q?E/q5qsejsxD8J/WB/szEZCDuWDRlUaiYAtRGQgaSinz/5C74tMVRwW/yJX3H?=
 =?us-ascii?Q?EUiXZ7GxpZN62+yp580qaHe7PIPMC8kKFZkFk7ljjFRaEQg+9NLndqogyKwE?=
 =?us-ascii?Q?iwZ9l9pMncIBoKMIjdsJAeQQQMXGQXw9oPIImGuywtGdtE3wbN1E9GcvHXRs?=
 =?us-ascii?Q?k4DrM/U0P0GUFOUIL/5VaytxUIkxxnB9hrXyikttt7IxVl3s1MLNSvq+jWjb?=
 =?us-ascii?Q?5Uxg940ltMzWd+m0nr5KO+nPXnQi9wIFIk/R6Wg2D6XclxyThMAF627k0fyC?=
 =?us-ascii?Q?aB43FL74Wo2W3vpVLC2ZhAm3QfQ+UTHUGpAWfPs4wFliqSmbSA8k8LbKR4hJ?=
 =?us-ascii?Q?8egjuBBu1jVFdE3ibdV/iolBnzyx93DvCbgPV4zP2AzvP1/lQkOSJjbQF5Nx?=
 =?us-ascii?Q?zJkQ4QaJZIGfYJpQpYcrxe5HgFOJhFAVc7HQRzZV37gOIm+47QoC4FFGHom6?=
 =?us-ascii?Q?ocfuH6nBhZHkpNtDOlx0WFRe2AYSrJZCQVdtV0RJTBdiUd2pwzK0gkGKP77i?=
 =?us-ascii?Q?sbPA1XkiWBtzfwBPf/gF/LLFp5KW1aqTqBxx/lUo1MYnCvQWVzwvWtSQ2jS8?=
 =?us-ascii?Q?p31eqZIAh3iIN85pF2+R3nVkN9AKcWwXcvG/wZhYneJ2HYbdKI8YTpuOqSYK?=
 =?us-ascii?Q?UM151BVZp9GAdH9Sl7uaBb+9WUg/3YXrcvcDsbOV6AyVkO0V0eFQmfPQ/KW9?=
 =?us-ascii?Q?cxRgn7mNhI/8vyDrLr0lITZO0t7aw/szXGHhASqg6W9/kk9vXY3qu+OAtJTU?=
 =?us-ascii?Q?CZW062TbTOp0RIWm26PcV1l8lhHfXD6bv3ePBQQe8YajLE7X97bvgU6hE5ET?=
 =?us-ascii?Q?LVZlgYIeWG5BGhPLCDRikFhc2OCGmuCpYJOelLlDoptYcZYGe/w3Zw4TqLMz?=
 =?us-ascii?Q?U1bQ3mnlz3VighHv1rhTLrK3wBsu5eV6pGzMN2zxKhIRS9wZjFcZC+LFUcg7?=
 =?us-ascii?Q?/0VUJecbrfm08zEX740iIl8FAP8/ipxqV5iPsPZY?=
Content-Type: multipart/alternative;
	boundary="_000_GV0P278MB0099DBAA231307BBD2AFA1038B6C2GV0P278MB0099CHEP_"
MIME-Version: 1.0
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-Network-Message-Id: 2ba71685-014c-4d1d-aee5-08dcd94a71fd
X-MS-Exchange-CrossTenant-originalarrivaltime: 20 Sep 2024 08:01:34.2829
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 9f489fcc-e452-4509-8234-6f97b42d0117
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: FRhz6JjtDfo7D6cqgwhacfHrw5/4HTst7xZmc5ZYIHMdmjR9ZNQxQCmM2xtmUy/dHHPLpmgeedgg+YJ73f1ljpUkZNDbTs3KS7RrSHtHwpw=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: ZRAP278MB0826
X-OriginatorOrg: zuerich.ch
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/GV0P278MB0099DBAA231307BBD2AFA1038B6C2%40GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM>
Precedence: bulk

--_000_GV0P278MB0099DBAA231307BBD2AFA1038B6C2GV0P278MB0099CHEP_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

The Postgres instance is running on timezone CEST (parameter timezone =3D '=
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=3D2024-09-19 1=
7:00:00+02") although OS is running on UTC.

Agreed?






--_000_GV0P278MB0099DBAA231307BBD2AFA1038B6C2GV0P278MB0099CHEP_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:Wingdings;
	panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Consolas;
	panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	font-size:11.0pt;
	font-family:"Arial",sans-serif;
	mso-ligatures:standardcontextual;
	mso-fareast-language:EN-US;}
span.E-MailFormatvorlage35
	{mso-style-type:personal-compose;
	font-family:"Arial",sans-serif;
	font-variant:normal !important;
	color:windowtext;
	text-transform:none;
	position:relative;
	top:0pt;
	mso-text-raise:0pt;
	letter-spacing:0pt;
	mso-ligatures:none;
	mso-number-form:default;
	mso-number-spacing:default;
	mso-stylistic-set:0;
	mso-contextual-alternates:no;
	font-weight:normal;
	font-style:normal;
	text-decoration:none none;
	vertical-align:baseline;}
.MsoChpDefault
	{mso-style-type:export-only;
	mso-fareast-language:EN-US;}
.MsoPapDefault
	{mso-style-type:export-only;
	margin-bottom:10.0pt;
	line-height:115%;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
	{page:WordSection1;}
/* List Definitions */
@list l0
	{mso-list-id:-120;
	mso-list-type:simple;
	mso-list-template-ids:-2036700426;}
@list l0:level1
	{mso-level-style-link:Listennummer;
	mso-level-tab-stop:18.0pt;
	mso-level-number-position:left;
	margin-left:18.0pt;
	text-indent:-18.0pt;}
@list l1
	{mso-list-id:-119;
	mso-list-type:simple;
	mso-list-template-ids:1072705328;}
@list l1:level1
	{mso-level-number-format:bullet;
	mso-level-text:\F0B7;
	mso-level-tab-stop:18.0pt;
	mso-level-number-position:left;
	margin-left:18.0pt;
	text-indent:-18.0pt;
	font-family:Symbol;}
@list l2
	{mso-list-id:99691344;
	mso-list-type:hybrid;
	mso-list-template-ids:-435887208 -755725786 134676483 134676485 134676481 =
134676483 134676485 134676481 134676483 134676485;}
@list l2:level1
	{mso-level-number-format:bullet;
	mso-level-style-link:Aufz\00E4hlungszeichen;
	mso-level-text:\F0B7;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:Symbol;}
@list l2:level2
	{mso-level-number-format:bullet;
	mso-level-text:o;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:"Courier New";}
@list l2:level3
	{mso-level-number-format:bullet;
	mso-level-text:\F0A7;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:Wingdings;}
@list l2:level4
	{mso-level-number-format:bullet;
	mso-level-text:\F0B7;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:Symbol;}
@list l2:level5
	{mso-level-number-format:bullet;
	mso-level-text:o;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:"Courier New";}
@list l2:level6
	{mso-level-number-format:bullet;
	mso-level-text:\F0A7;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:Wingdings;}
@list l2:level7
	{mso-level-number-format:bullet;
	mso-level-text:\F0B7;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:Symbol;}
@list l2:level8
	{mso-level-number-format:bullet;
	mso-level-text:o;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:"Courier New";}
@list l2:level9
	{mso-level-number-format:bullet;
	mso-level-text:\F0A7;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:Wingdings;}
ol
	{margin-bottom:0cm;}
ul
	{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"DE-CH" link=3D"blue" vlink=3D"purple" style=3D"word-wrap:brea=
k-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.0pt;mso-l=
igatures:none">The Postgres instance is running on timezone CEST (parameter=
 timezone =3D 'Europe/Zurich') which is UTC+2.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.0pt;mso-l=
igatures:none"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.0pt;mso-l=
igatures:none">The underlying Linux OS (K8s container) is running on timezo=
ne UTC.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.0pt;mso-l=
igatures:none"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.0pt;mso-l=
igatures:none">Backups are done with pgBackRest.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.0pt;mso-l=
igatures:none"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.0pt;mso-l=
igatures:none">With PITR we will have to use target timezone CEST (--target=
=3D2024-09-19 17:00:00+02&quot;) although OS is running on UTC.<o:p></o:p><=
/span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.0pt;mso-l=
igatures:none"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.0pt;mso-l=
igatures:none">Agreed?<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.0pt;mso-l=
igatures:none"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.0pt;mso-l=
igatures:none"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.0pt;mso-l=
igatures:none"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.0pt;mso-l=
igatures:none"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.0pt;mso-l=
igatures:none"><o:p>&nbsp;</o:p></span></p>
</div>
</body>
</html>

--_000_GV0P278MB0099DBAA231307BBD2AFA1038B6C2GV0P278MB0099CHEP_--