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 1l9Qs9-0004jl-1g for pgsql-admin@arkaria.postgresql.org; Tue, 09 Feb 2021 11:07:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l9Qs7-0008BH-SP for pgsql-admin@arkaria.postgresql.org; Tue, 09 Feb 2021 11:07:55 +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 1l9Qs7-0008B9-LI for pgsql-admin@lists.postgresql.org; Tue, 09 Feb 2021 11:07:55 +0000 Received: from admin.sibptus.ru ([2001:19f0:5001:21dc::10]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l9Qs5-0006Jv-Gy for pgsql-admin@lists.postgresql.org; Tue, 09 Feb 2021 11:07:55 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=sibptus.ru; s=20181118; h=In-Reply-To:Message-ID:Subject:To:From:Date; bh=JW8CfTF6AQ2Sm66GLA2+mviyj6/A8M4bbSTHYz49rC0=; b=SoXAY53D0ncRmGo5bNWoL1bJSS CvM994M3lR9SVMbHaYWSP8WwX7OW3hHTrgpOqKU0R0CWA2l+VeiQjmq0jC1ZVz12wmbeqU51fnqzd GrJSI72j5pZOVyJDdqxwuQhVh2w0QeIbZbBpJOM/fktk114GxmZGaVMwYZbcGQJ1OHDY=; Received: from vas by admin.sibptus.ru with local (Exim 4.94 (FreeBSD)) (envelope-from ) id 1l9Qs4-000MTZ-G8 for pgsql-admin@lists.postgresql.org; Tue, 09 Feb 2021 18:07:52 +0700 Date: Tue, 9 Feb 2021 18:07:52 +0700 From: Victor Sudakov To: pgsql-admin@lists.postgresql.org Subject: Re: wal-g (https://github.com/wal-g/wal-g) reliability Message-ID: References: <7377779A-6763-415E-B132-0998957626FA@yandex-team.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: X-PGP-Key: http://admin.sibptus.ru/~vas/ X-PGP-Fingerprint: 10E3 1171 1273 E007 C2E9 3532 0DA4 F259 9B5E C634 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Andrey Borodin wrote: > > > > 9 февр. 2021 г., в 15:12, Victor Sudakov написал(а): > > > > I'm considering WAL-G now, not as a backup solution per se, but as an > > advanced WAL archiver which can: > Keep in mind that once upon a time you will have to delete WAL segments. If you just use wal-g delete you have to point our which backup to keep. Thank you, this is an important note. > > > 1. Upload/download WALs directly to S3 > > > > 2. Verify WALs integrity (a very nice feature, but I think does not work > > if there are no backups) > If will not be alarmed if WALs before backup are missing. Though it should still analyze chains correctly. > > > 3. Prevent WAL overwrite (does it work?) > I think so. > OK. -- Victor Sudakov, VAS4-RIPE, VAS47-RIPN 2:5005/49@fidonet http://vas.tomsk.ru/