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 1mPrs1-0001vp-Qj for pgsql-admin@arkaria.postgresql.org; Mon, 13 Sep 2021 19:44:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mPrs0-0007pV-OV for pgsql-admin@arkaria.postgresql.org; Mon, 13 Sep 2021 19:44:00 +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 1mPrs0-0007pM-F4 for pgsql-admin@lists.postgresql.org; Mon, 13 Sep 2021 19:44:00 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mPrrx-0003QA-Vu for pgsql-admin@lists.postgresql.org; Mon, 13 Sep 2021 19:43:59 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id AE15D5F799; Mon, 13 Sep 2021 15:43:55 -0400 (EDT) Date: Mon, 13 Sep 2021 15:43:55 -0400 From: Stephen Frost To: Gokan Atmaca Cc: Victor Yegorov , pgsql-admin@lists.postgresql.org Subject: Re: PgBackRest PITR restore Message-ID: <20210913194355.GG17906@tamriel.snowman.net> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="KFqA3NAzXT9iu/Yo" 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: Archived-At: Precedence: bulk --KFqA3NAzXT9iu/Yo Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Gokan Atmaca (linux.gokan@gmail.com) wrote: > > Look for --db-include >=20 > This option restores a single database but corrupts the others. Is it > necessary to take a backup with "pg_dump" before doing this? "Corrupts" is only kind of correct- it explicitly doesn't restore the other databases (since you asked for just one to be restored) and makes it such that you're not able to log into them. Performing an export with pg_dump is one approach to getting a point in time view of all of the data in a given database, but you won't be able to perform PITR-style restore with pg_dump's. Thanks, Stephen --KFqA3NAzXT9iu/Yo Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJhP6n7AAoJEO1sijiDR2RVu78P/2sRizgwyn4XljX2t2gPXMt8 1Xgv8nDLbcBjXhVqHv+cpUaSyPXEw3XQRy/P5DfdpfndIBENusAsb6a4ksWsg0iS TIx2Nw3H0dqvpf+r5TOotV20x4jqoCnS7vg0n9FbSdq96HcSvsaKC7/dxe5e1D2w TzjLn/YmsLrG8jl/A/f1cpX4Tu3GvxGKmr3vmlfRRUNqFDAH3CsWG4F3raHx8c+B JAA8aEvAdjGPuem94NQH7vGvNt+2GPE1mRsDsujIEVXF9cml/5OEJZo/n0pzS42W MXMiv6q+qOz+Dtffia3ySBn5LtFGUG3f20Pp2skovFaJUwwJCOtm9ciciFei6Et6 4LI8x5q1tNHDGgi2FHRiBE4fEXttPPjX77dL8Hi7ay7g7a7v0rXxvjIKqgMuJqZG ic53gzWGtSaYZ1w/irteAM6dmc3D0rGGCYiQt/6+AdBRzGn3CvbwX94aVhUuRPwj Jnd5mPbrYZkxIiif0ntjuRi7eo04uLcp5D0r8p2TzQMSAnWbokzB0+3QctweBhAI zNfFQM/BJLcExHmTEtoYlJuA6alSp6lkVmv1/9hHqr1rf5QAGCEfHporHXVfsavH x3t6fHNEprN8icP61Mnrh0ZMM7HyEB6tKtYC+es86oJU6W0aT6yR1V4vOibewhJO yN5kFyzvUWVRcejOYe32 =iBa/ -----END PGP SIGNATURE----- --KFqA3NAzXT9iu/Yo--