Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m70e2-0000Hi-2E for pgsql-admin@arkaria.postgresql.org; Fri, 23 Jul 2021 19:15:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m70e1-00049n-13 for pgsql-admin@arkaria.postgresql.org; Fri, 23 Jul 2021 19:15:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m70e0-00049f-Oa for pgsql-admin@lists.postgresql.org; Fri, 23 Jul 2021 19:15:36 +0000 Received: from mail.am-soft.de ([83.218.36.120]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m70dy-0005Ld-7f for pgsql-admin@lists.postgresql.org; Fri, 23 Jul 2021 19:15:36 +0000 Received: from mail.am-soft.de (localhost [127.0.0.1]) by mail.am-soft.de (Postfix) with ESMTP id 9ACEE3E20F8F; Fri, 23 Jul 2021 21:15:33 +0200 (CEST) Received: from Bit02EX.bitstoregruppe.local (exchange01.bitstore.group [116.202.141.225]) by mail.am-soft.de (Postfix) with ESMTPA id 8DCE53E20F8D for ; Fri, 23 Jul 2021 21:15:33 +0200 (CEST) Received: from tschoening-nb.fritz.box (77.78.163.99) by Bit02EX.bitstoregruppe.local (192.168.254.21) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.2106.2; Fri, 23 Jul 2021 21:15:19 +0200 Date: Fri, 23 Jul 2021 21:15:17 +0200 From: =?utf-8?B?VGhvcnN0ZW4gU2Now7ZuaW5n?= Organization: AM-SoFT IT-Service - Bitstore Hameln GmbH Message-ID: <1837868909.20210723211517@am-soft.de> To: Subject: Re: What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL? In-Reply-To: <6780C96C-3016-47C8-AD06-BF860283266C@elevated-dev.com> References: <1208702063.20210723115638@am-soft.de> <399c734c5b9ffe10f68bcb79a69bea000d8d0c21.camel@cybertec.at> <1751752722.20210723161202@am-soft.de> <20210723152418.GK20766@tamriel.snowman.net> <562203777.20210723194435@am-soft.de> <6780C96C-3016-47C8-AD06-BF860283266C@elevated-dev.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Originating-IP: [77.78.163.99] X-ClientProxiedBy: Bit02EX.bitstoregruppe.local (192.168.254.21) To Bit02EX.bitstoregruppe.local (192.168.254.21) X-C2ProcessedOrg: e1a4acb5-ea26-4a8f-9559-e23e579650e8 X-AV-Checked: ClamAV using ClamSMTP List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Guten Tag Scott Ribe, am Freitag, 23. Juli 2021 um 20:07 schrieben Sie: > Because it is in the file. WAL can re-do changes, it cannot undo them. But isn't visibility of rows associated to transaction numbers as well? I would have expected the transaction number for the row in B simply not being available, because it was never part of the WALs up to and including pg_stop_backup when not following the official ordering of commands. So I expected that row to simply not be visible at all and vacuumed at some point or whatever. Mit freundlichen Gr=C3=BC=C3=9Fen Thorsten Sch=C3=B6ning --=20 AM-SoFT IT-Service - Bitstore Hameln GmbH Mitglied der Bitstore Gruppe - Ihr Full-Service-Dienstleister f=C3=BCr IT u= nd TK E-Mail: Thorsten.Schoening@AM-SoFT.de Web: http://www.AM-SoFT.de/ Tel: 05151- 9468- 0 Tel: 05151- 9468-55 Fax: 05151- 9468-88 Mobil: 0178-8 9468-04 AM-SoFT IT-Service - Bitstore Hameln GmbH, Brandenburger Str. 7c, 31789 Ham= eln AG Hannover HRB 221853 - Gesch=C3=A4ftsf=C3=BChrer: Janine Galonska F=C3=BCr R=C3=BCckfragen stehe ich Ihnen sehr gerne zur Verf=C3=BCgung. Mit freundlichen Gr=C3=BC=C3=9Fen Thorsten Sch=C3=B6ning Tel: 05151 9468 0 Fax: 05151 9468 88 Mobil:=20 Webseite: https://www.am-soft.de=20 AM-Soft IT-Service - Bitstore Hameln GmbH i.G.=C2=A0ist ein Mitglied der Bi= tstore Gruppe - Ihr Full-Service-Dienstleister f=C3=BCr IT und TK AM-Soft IT-Service - Bitstore Hameln GmbH i.G. Brandenburger Str. 7c 31789 Hameln Tel: 05151 9468 0 Bitstore IT-Consulting GmbH Zentrale - Berlin Lichtenberg Frankfurter Allee 285 10317 Berlin Tel: 030 453 087 80 CBS IT-Service - Bitstore Kaulsdorf UG Tel: 030 453 087 880 1 B=C3=BCro Dallgow-D=C3=B6beritz Tel: 03322 507 020 B=C3=BCro Kloster Lehnin Tel: 033207 566 530 PCE IT-Service=C2=A0- Bitstore Darmstadt UG Darmstadt Tel: 06151 392 973 0 B=C3=BCro Neuruppin Tel: 033932 606 090 ACI EDV Systemhaus - Bitstore Dresden GmbH Dresden Tel: 0351 254 410 Das Systemhaus - Bitstore Magdeburg GmbH Magdeburg Tel: 0391 636 651 0 Allerdata.IT - Bitstore Wittenberg GmbH Wittenberg Tel: 03491=C2=A0876 735 7 B=C3=BCro Liebenwalde Tel: 033054 810 00 HSA - das B=C3=BCro - Bitstore Altenburg UG Altenburg Tel: 0344 784 390 97 Bitstore IT =E2=80=93 Consulting GmbH NL Piesteritz=20 Piesteritz Tel: 03491 644 868 6 Solltec IT-Services - Bitstore Braunschweig UG Braunschweig Tel: 0531 206 068 0 MF Computer Service - Bitstore G=C3=BCtersloh GmbH G=C3=BCtersloh Tel: 05245=C2=A0920 809 3 Firmensitz: AM-Soft IT-Service - Bitstore Hameln GmbH i.G. , Brandenburger = Str. 7c , 31789 Hameln Gesch=C3=A4ftsf=C3=BChrer Janine Galonska