Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i33h1-0007bw-LI for pgsql-admin@arkaria.postgresql.org; Wed, 28 Aug 2019 19:33:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1i33h0-0002u9-Hn for pgsql-admin@arkaria.postgresql.org; Wed, 28 Aug 2019 19:33:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i33h0-0002tf-5s for pgsql-admin@lists.postgresql.org; Wed, 28 Aug 2019 19:33:18 +0000 Received: from tamriel.snowman.net ([96.255.250.162]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1i33gx-00042D-R5 for pgsql-admin@lists.postgresql.org; Wed, 28 Aug 2019 19:33:16 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 8C95D5F79F; Wed, 28 Aug 2019 15:33:15 -0400 (EDT) Date: Wed, 28 Aug 2019 15:33:15 -0400 From: Stephen Frost To: Licio Matos Cc: Jeff Janes , pgsql-admin@lists.postgresql.org Subject: Re: Backup From HotStandby Message-ID: <20190828193315.GZ16436@tamriel.snowman.net> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="c3RWj8KdWspvOaIe" 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 --c3RWj8KdWspvOaIe Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Greetings, * Licio Matos (licio.matos@gmail.com) wrote: > But in this case i am not using pg_basebackup, but i make pg_start_backup() > and pg_stop_backup() in the script and make a snapshot. > So, i believe this work too, right? No, that doesn't work. The pg_basebackup method does. Thanks, Stephen --c3RWj8KdWspvOaIe Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJdZtb7AAoJEO1sijiDR2RVTs8QAKNGcIWbzP3N4pwNX0FM8g3k HnXlMGIAaZxjRvW2OvZYiN3iFdYZaaxaTowcMvWMRjpffNvwPzZ41duhPABHeUcb Yijoq+EMn28NHDlVCxKo/KBx9tW5c0tEiCaVriBpVckoUeS3thyHygAGtFbxw3fQ gD57zsXJvMXxVs5+2DYLP+JMT2Xt7eMYpEsILk+nHxvBckMVteVvzE8gFS/AWhQH fT+jEr+U1grkdzAYMygHsL7pWcko+VEIwK26OeSM44N+uNPO3atALKAaigXwtPdM 0Wy9HLQzGFWMzZGzcBLjAzFtEGx4Lx/3oHHBiI7jUC+T3VTNzHy9Rp6qzfjfMSHQ JQE+w2S+vO2S1H+ihs+/j9qWKmFraJzzc+iuCRL5t64FBCXe5baGJOpljcSzu/hw gt4dXk9z101Nc+BDEjlskw/TTx1/Y5BVeb5Jrlzm9jiSYvUyNlqBZzN8kBBek/Ie 4c8Cp2d114WEfkW654qOTxZ0zZVi9mFWMWMj9BwSl1JiKYMhhzZbdS5HVQ9BMgjg z71jDDx1+kb3IbbD2IKuAaEvbCpGpFLRUgLcLHvO2XOVzF91od9JP0Y8lX0WIvzE bhy8Zw+MeR60tSCNa1eEOvOGP7UObUkposaSKyYyg5Rlk5hqzVw46Z5CgM+lcuWY 8y0qnCl1biMpQLQYAQsm =Ykc+ -----END PGP SIGNATURE----- --c3RWj8KdWspvOaIe--