Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cUYE6-00019k-1O for pgsql-performance@arkaria.postgresql.org; Fri, 20 Jan 2017 12:23:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cUYE5-00015Q-Hb for pgsql-performance@arkaria.postgresql.org; Fri, 20 Jan 2017 12:23:29 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cUYE4-00015H-Jn for pgsql-performance@postgresql.org; Fri, 20 Jan 2017 12:23:28 +0000 Received: from tamriel.snowman.net ([72.66.115.51]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cUYE1-0006Hb-Bu for pgsql-performance@postgresql.org; Fri, 20 Jan 2017 12:23:27 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id C502F5F796; Fri, 20 Jan 2017 07:22:24 -0500 (EST) Date: Fri, 20 Jan 2017 07:22:24 -0500 From: Stephen Frost To: Pavel Stehule Cc: Dinesh Chandra 12108 , "Madusudanan.B.N" , "pgsql-performance@postgresql.org" Subject: Re: Backup taking long time !!! Message-ID: <20170120122224.GF18360@tamriel.snowman.net> References: <0fb0c8c3f69340a3a7d70b1c39fa2b2c@cyient.com> <23dc5b1ea9604ec3afdaabdd15491085@cyient.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="mFOTU3doHY2V53n6" Content-Disposition: inline In-Reply-To: X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.13.0-91-generic (x86_64) X-Uptime: 07:20:11 up 195 days, 13:44, 2 users, load average: 0.22, 0.23, 0.14 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --mFOTU3doHY2V53n6 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * Pavel Stehule (pavel.stehule@gmail.com) wrote: > 2017-01-20 12:53 GMT+01:00 Dinesh Chandra 12108 : > > Thanks for quick response. > > > > May I know how can I use physical full backup with export transaction > > segments. > > >=20 > https://www.postgresql.org/docs/9.1/static/continuous-archiving.html >=20 > This process can be automatized by some applications like barman > http://www.pgbarman.org/ Last I checked, barman is still single-threaded. If the database is large enough that you need multi-process backup, I'd suggest looking at pgbackrest- http://www.pgbackrest.org. pgbackrest has parallel backup, incremental/differential/full backup support, supports compression, CRC checking, and a whole ton of other good stuff. Thanks! Stephen --mFOTU3doHY2V53n6 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJYggEAAAoJEO1sijiDR2RV2QYQAKkNl8cQWHykKVqd4UgVs0KB GexgxGtjizzKkyU5uHH5LRboGvuNHXjk3PkoRcz8fxsKF3NiTN5mnXEFA+gzGABR TnXhhY04F6kdjaa0WZ4rsMGqsb8A63y2xMZyGy+Zcoqfifb7Via2Hy9Hj/Fc1V+Q UTh77Ch1makz3wBnxfT2a3n1zze+vxOe2k2mNA6eRjEPqyq5r/+gfvpklWGLzGKG jXiLSri4rN9a/CY4FSt+Q6p38ucdBjU9hAjv+uW3vWPGRLCjLIhy31rmcdMvX/Qt i4/NFE4Ecv6MDYYREu2Oxa/yLCB9zMAE0IAbNf2qfDcdjJndaBbMPBXAoe1XxhGa UNEAiWGs5WAge/QRRiNGqfp/in/GEWGojbExE68JpUw3gA+/idcMWGQDvDbSM2TJ GGFA5dFV1k+idjbqOgsOFw4TEnSIigZ1SNPpmFhIbCbL93EH/YB+CMk5g2GDp0ho RDce5iSetUcxKe7gMzoc7TCW7kqMIr25pSKNe40RF7ZnHCyFLY091DyHSh2H6nlE Wx2jRmEP4O3Id3Leig+NYbaqRNJsld9KMGx07VIa66napHFqKRX2nh08Te7VOijv sJpykI91R5oBfwl/FS6+801qfx7+MIH6UdCZpOfNLQHayIdZGthUgVuT+Aa6UR0/ s35LKndx85UPWtJO6V8r =xxAh -----END PGP SIGNATURE----- --mFOTU3doHY2V53n6--