Date: Sun, 22 Jan 2017 09:57:40 -0500
From: Stephen Frost <sfrost@snowman.net>
To: julyanto SUTANDANG <julyanto@equnix.co.id>
Cc: Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: Backup taking long time !!!
Message-ID: <20170122145740.GE18360@tamriel.snowman.net>
References: <0fb0c8c3f69340a3a7d70b1c39fa2b2c@cyient.com>
 <CAGu3fER+B6dFk=7F+DEMPPOSerYZs0HZMOfVAkbKs5Gdi-B-mg@mail.gmail.com>
 <CAGu3fERNACLx23C9uARdCb98TJWY_Nd+bMGsBsmo6A8vy01p+A@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="3C1+oG8NxxW+Hf7i"
Content-Disposition: inline
In-Reply-To: 
 <CAGu3fERNACLx23C9uARdCb98TJWY_Nd+bMGsBsmo6A8vy01p+A@mail.gmail.com>
User-Agent: Mutt/1.5.21 (2010-09-15)
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org


--3C1+oG8NxxW+Hf7i
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Greetings,

* julyanto SUTANDANG (julyanto@equnix.co.id) wrote:
> CORRECTION:
>=20
> "you might you pg_start_backup to tell the server not to write into the
> DATADIR"
>=20
> become
>=20
> "you might *use* pg_start_backup to tell the server not to write into the
> *BASEDIR*, actually server still writes but only to XLOGDIR "

Just to make sure anyone reading the mailing list archives isn't
confused, running pg_start_backup does *not* make PG stop writing to
BASEDIR (or DATADIR, or anything, really).  PG *will* continue to write
data into BASEDIR after pg_start_backup has been called.

The only thing that pg_start_backup does is identify an entry in the WAL
stream, from which point all WAL must be replayed when restoring the
backup.  All WAL generated from that point (pg_start_backup point) until
the pg_stop_backup point *must* be replayed when restoring the backup or
the database will not be consistent.

Thanks!

Stephen

--3C1+oG8NxxW+Hf7i
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBCgAGBQJYhMhkAAoJEO1sijiDR2RVj3kP/A0KrtICl/D9KuG5EMClgyZH
YKH00KN3a9/7BOkyp4JbasC8nJoBw64MmrwF5ANVSNzmG/53VuLHDtNjdE/VaWwd
2ODxzCIIagidMe2iVJewJiYlhJV/Z2NvhVW44flUGHWP77wkGpOKxuvMwFl/ADhh
2tfmToRcFyixy8njPBfdAVTiKGX503Rs3rzbqY58w8DcyaGPpkn8QuOEzuNKtvZQ
WSBOKieoMblQVzq6YSLf7BGNJOv7rBqy5DeeYPa0Bctl/PVw8yvI9I118LCudmQB
FCFROuz2GDo672wxnY0zQUAjRfQaOxntXNl2a6njuLf4gNKCVcIbOJYZgCWguoQq
QAxm4vdqyIBCWabSTTBYUyaSCqwohWaCy7Y/5Hc9d+1lEkV8SulFzRnb8EE+aO/v
98s/LSCSRXNv5uIRGcPMa3kpLQjGkTVMukeE+w9o1uMvG0CYUJ43QHtRCLeTmz0p
b4/ryTzmas/rSFZCs2uniriAM9NtQhbR1k6UAsUXMT+MpD+LYH4thZfz4vzN62Q9
5oCy9Ww6x2tul+13MddUDXW8EtiwVQwEinJ9xWkfwa5VtNGwux+/1VPIjan1CVV7
/sCRB8bU4XhmqFwLVw9jhX0lBiZHN9cHF2TZvD0cn7V/AxgyX1zWhfMxcDwQIkX5
Mj998Mh3xF4AhzYq87S2
=g9x5
-----END PGP SIGNATURE-----

--3C1+oG8NxxW+Hf7i--