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 1m8Q8t-0007cP-8F for pgsql-admin@arkaria.postgresql.org; Tue, 27 Jul 2021 16:41:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m8Q8r-0007UZ-Vp for pgsql-admin@arkaria.postgresql.org; Tue, 27 Jul 2021 16:41:17 +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 1m8Q8r-0007UR-EW for pgsql-admin@lists.postgresql.org; Tue, 27 Jul 2021 16:41:17 +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 1m8Q8o-0006sS-Hx for pgsql-admin@lists.postgresql.org; Tue, 27 Jul 2021 16:41:17 +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=qlsAmexXE4U/TSygYK425zdRh9NOys6lyZUijeSxmr8=; b=HuOb8osey+Pho9Z24Mis7ltGnb Toy+qZEGpk0KSDwDUp1d341r6V7Q1Y/M3AVJj1tdlJteAypersxEZ8tjb5ujQDAd61EJXNsyGazaF gJD7Tci3EUiYqdOV+jcdEVtuPhljn8uBwsYnuPBIL60Gs0BjhDRUZfbm5JfP+KQjeM3Q=; Received: from vas by admin.sibptus.ru with local (Exim 4.94.2 (FreeBSD)) (envelope-from ) id 1m8Q8k-000NBJ-QX; Tue, 27 Jul 2021 23:41:10 +0700 Date: Tue, 27 Jul 2021 23:41:10 +0700 From: Victor Sudakov To: Scott Ribe Cc: Pgsql-admin Subject: Re: Running PostgreSQL in Kubernetes? Message-ID: References: <353A1D55-3DFF-43B1-B906-147C9C511435@elevated-dev.com> <2B89961F-4400-4523-9CCA-A2A9000E713C@elevated-dev.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="2/q6x0AS+05TTqCI" Content-Disposition: inline In-Reply-To: <2B89961F-4400-4523-9CCA-A2A9000E713C@elevated-dev.com> 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: Archived-At: Precedence: bulk --2/q6x0AS+05TTqCI Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Scott Ribe wrote: > > On Jul 27, 2021, at 12:57 AM, Victor Sudakov wrote: > >=20 > > Have you been able to a) upload backups to S3 and b) perform PITR from > > S3 with CrunchyData? >=20 > I have never tried either. >=20 > I have recovered from the backups,=20 Using the CrunchyData operator built-in backup service? > but never used PITR from the WAL archives. It's really very efficient and elegant with wal-g. wal-g fetches data =66rom S3 in parallel and can prefetch.=20 I've done PITR from S3 many times in a lab, and a couple of times on real data. But to use wal-g inside Kubernetes, I probably need Zalando's operator which I dislike. --=20 Victor Sudakov VAS4-RIPE http://vas.tomsk.ru/ 2:5005/49@fidonet --2/q6x0AS+05TTqCI Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQEcBAEBAgAGBQJhADcmAAoJEA2k8lmbXsY0nI8IAINgpGmZIytvvotoSHu0fKUV IIyoIYmRbPZfF94FZCR8+5LuwyBVgWykjkDnE/cOJQn+Lhk1g+Xc5zPsuolQC+rC kVFoMb8LXwB6oNtt3NbD9qBaavFaijmnjZLRY3HBgcfT0ynGN7VlQI357SpPZD8Z le4019QUtoJy6wV9OtMX9hHnj8pJmPEibSwNDvZtpLbxVdP3RxF8iArFOQ4WgPmG ein3dVF3KqibGTFSSMpyrVy56YcC1c9eHxqMIIf0lgD7hWeYG/WO4JYvRqWzV89B Y/z16Yimw3NPYlKce3Be8D9OTXMYkKXoDkGmrbSckUnXgAWRL8JUnVWgpU1uwCI= =HBLw -----END PGP SIGNATURE----- --2/q6x0AS+05TTqCI--