Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gAwEJ-0003hG-PD for pgsql-admin@arkaria.postgresql.org; Fri, 12 Oct 2018 12:07:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gAwEI-0000S6-0l for pgsql-admin@arkaria.postgresql.org; Fri, 12 Oct 2018 12:07:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gAwEH-0000Rz-PD for pgsql-admin@lists.postgresql.org; Fri, 12 Oct 2018 12:07:41 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gAwEF-0003kF-3y for pgsql-admin@postgresql.org; Fri, 12 Oct 2018 12:07:40 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 8D8F65F79C; Fri, 12 Oct 2018 08:07:38 -0400 (EDT) Date: Fri, 12 Oct 2018 08:07:38 -0400 From: Stephen Frost To: "For@ll" Cc: pgsql-admin@postgresql.org Subject: Re: Pgbackrest Message-ID: <20181012120738.GQ4184@tamriel.snowman.net> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="0DjylEV0DRrUlu3h" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0DjylEV0DRrUlu3h Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * For@ll (forall@stalowka.info) wrote: > For now I use OmniPITR for backup and replication with postgresql, but > we looking something else and I find pgbackrest, so I have a few question= s: >=20 > - use OmniPITR for streaming replication I have 2 way protection, when > slave long time off,after start, postgresql restore data from wal before > switching to the streamgin replication from postgresql. > It's possible to do in pgbackrest? Yes, when you do a restore with pgbackrest, the recovery.conf will be set up to pull WAL from the repository to catch up. > - in pgbackrest streaming replication it can be only with "async state"? Note that pgbackrest doesn't use streaming replication for WAL as it's too slow, we use archive_command instead (and will run multiple parallel workers to get ahead of where archive_command is at, if there's WAL available to process and parallel workers are configured). It doesn't matter to pgbackrest if the replication between your primary and replica is synchronous or asycnhronous. Thanks! Stephen --0DjylEV0DRrUlu3h Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJbwI6KAAoJEO1sijiDR2RV/EgP/Rm/x/Dpzpr6yxuLAlUTVbY8 89XWrOY11mJ5EKC2ZyvuSLZZLY5ldKvUcRa2hvcgl2IyiLrE5Ikn23dm+PSI+FYG m4nIpauuILZ6fxhlqs1falzOWzHgiOh9ucTIy2RG25j+havs7fg1B414E5TS8A/C 4m3zPpZafUsr4JTVvcOc4KpNDEICNMcwR3YO5jyqlxgAVL6dC3QCv60LlA7casD/ nhUVw/N+XJ3uHItQ/QWOoqEjlva12c7psk8236AXUlF74aRLk3ybLPXVsnNUthe6 73qxUhETTzjHgui54yfHAsy4eafCFpX4GPP3++MLOv0wCzOhucfsz/zHJX4jZJKJ d/XFfgmbmlzIOmNaBqGUJWYXgmNZmg59/01ianem1eqDyZ+Xr5xWy6pilrlF2Q49 DcTUGef7/M+YP5vvUiXGh7QGu+r05dDhRcNq4F9c5HZzgHtSlI5ebCAqjPDYdBH6 GY3ajGkWtcgwDqCUt/puT2OaniA3xv4lww3tiXAjRDK0SK73OozlVHmYa3dSZtIJ g1A+S8C7MD89ih1bXegQ5kAq5jMaIOdtRo11BI9bMM1jSPg3tfAV6k2/71uS8Uie UZEzqy4rXXgGedR1Nt9ykGDpKvSnCiuaDRg7yYuNM47F6uwgxtlMJHx7RaBeuppU q5BRw7hS390m9gD/gLm3 =IMt3 -----END PGP SIGNATURE----- --0DjylEV0DRrUlu3h--