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 1p2Pov-0007QG-C2 for pgsql-general@arkaria.postgresql.org; Tue, 06 Dec 2022 04:44:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p2Pot-0005xo-Ph for pgsql-general@arkaria.postgresql.org; Tue, 06 Dec 2022 04:44:39 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p2Pot-0005xf-Cp for pgsql-general@lists.postgresql.org; Tue, 06 Dec 2022 04:44:39 +0000 Received: from mail-wr1-x434.google.com ([2a00:1450:4864:20::434]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p2Pon-0001NO-0n for pgsql-general@lists.postgresql.org; Tue, 06 Dec 2022 04:44:38 +0000 Received: by mail-wr1-x434.google.com with SMTP id h12so21774626wrv.10 for ; Mon, 05 Dec 2022 20:44:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=dEo1iR1nXY7lMPTH71siT+JcgkUQz7cWIZdZfo9On5U=; b=pXkwwT1uh2ttCboX8+aSoqEiXSN8PuglQQOFD1F7t0GQ5kZuMMOBrBTsmFoQBOK318 AKzX/mHgOHWYnNuNrSGyE/25JsALW9BerV8qi0wBSvZit2oHqRjxrfuNGzBLLWk70jpR w5hk+6uVSFmjk+Qq9ihh2uZOiuSLH+B3zUYLh/aAItoDnD4BSl9TvdkTyaF0KdH/B/IA 2mVDgB9vVeR8oIQZf/TAYd7ll8YUwhz+zCOL46NcAB3iMjjH1b1hNW5zjbPlHmVG9lkM gzAalC61tdLMxPs2iUp8VkPdsP0dXY1D48wVYLwjeOIVkTHuGYgtqSDtF/sa4WJ87oDY rYuQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=dEo1iR1nXY7lMPTH71siT+JcgkUQz7cWIZdZfo9On5U=; b=ckjrLED+ZR4PmahU/Oo+C9J/3RL/5ALiE0Ucx6WsWB/2dIDL9D8QBg0ywOqKU7/FRc neDA4n64JObyHdFlKqUOuQbFSXcjcAOlov//HQlU3esYal0OjtFtkdtKQiStzShHir8z 432qQ8mNiJPGxjC80KkqPabOEhslkrpMSZwujIXLxIP2LntuFSFdDfsc3k4K27h/PKtp 2zdpUQ0dfvxz8wS8YlWNNag1uJsXueviUkZQhpItr+55MaAfOFnjAn9OgZSpIB4kj6PC xxO9mYD44hDuiGsFMOfRivLT+cCRFsLQDJ361e5u4CRQ9zp7CPFB31+geYxEBy/yubiE iTjg== X-Gm-Message-State: ANoB5pmXyz1BkU9Gqb9PwEMxKGMzkjYVOejlCpQr34i2+zojvCYx0xb9 uQDTx8EkfN4Z5+kQV3v+/Z8= X-Google-Smtp-Source: AA0mqf4CXg/013QXm4R1yWldvLq4Bs2OgjeolMZ7wh9E5qM1WpxQzSel1xPp82X+q9MqC5a4wyjhMQ== X-Received: by 2002:a05:6000:1c15:b0:242:28c9:d112 with SMTP id ba21-20020a0560001c1500b0024228c9d112mr17605596wrb.294.1670301870689; Mon, 05 Dec 2022 20:44:30 -0800 (PST) Received: from smtpclient.apple ([2c0f:f030:1300:1::2]) by smtp.gmail.com with ESMTPSA id fn7-20020a05600c688700b003c6b70a4d69sm19282864wmb.42.2022.12.05.20.44.27 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 05 Dec 2022 20:44:30 -0800 (PST) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.200.110.1.12\)) Subject: Re: postgres large database backup From: hvjunk In-Reply-To: <592a2c79-9728-e450-ad60-a0df7dd0f214@erven.at> Date: Tue, 6 Dec 2022 06:44:15 +0200 Cc: pgsql-general@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <52B3F216-2F91-4442-B6CA-7EE6FE960351@gmail.com> References: <9d50f118-a3dd-565a-41bd-d3056b9b90d6@gmail.com> <592a2c79-9728-e450-ad60-a0df7dd0f214@erven.at> To: Hannes Erven X-Mailer: Apple Mail (2.3731.200.110.1.12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 01 Dec 2022, at 01:19, Hannes Erven wrote: >=20 > You could also use a filesystem that can do atomic snapshots - like = ZFS. >=20 > However, I'm wondering why none of the previous respondents mentioned = it? the reason: 'cause most people are "stuck" on public clouds that does = not provide that as a "solution" in their cookie cutter (wrongly called = "managed") solutions... > Sure, ZFS may have its own performance implications... but my = experience is that it makes "safety snapshots" and "on-demand throw-away = testing environments" very convenient to use. Using that myself, but also as a VM in a ProxMox environmenet, I've = found (and restored) with ProxMox Backup Server goot single snapshot = backup solution. My cases doesn't need the PITR yet=