Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aRnPB-000693-Fy for pgsql-admin@arkaria.postgresql.org; Fri, 05 Feb 2016 20:55:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aRnPA-0000E0-Ve for pgsql-admin@arkaria.postgresql.org; Fri, 05 Feb 2016 20:55:01 +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) (envelope-from ) id 1aRnPA-0000Do-A2 for pgsql-admin@postgresql.org; Fri, 05 Feb 2016 20:55:00 +0000 Received: from tamriel.snowman.net ([2001:4830:167b::11]) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1aRnP7-00071U-OW for pgsql-admin@postgresql.org; Fri, 05 Feb 2016 20:54:59 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 508A15F795; Fri, 5 Feb 2016 15:54:57 -0500 (EST) Date: Fri, 5 Feb 2016 15:54:57 -0500 From: Stephen Frost To: Dave Johansen Cc: pgsql-admin@postgresql.org Subject: Re: Setting up streaming replication with new server as master? Message-ID: <20160205205456.GA3331@tamriel.snowman.net> References: <20160205202729.GZ3331@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="7DP64HymKb+JCWvF" 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-61-generic (x86_64) X-Uptime: 15:51:48 up 185 days, 5:22, 8 users, load average: 0.02, 0.06, 0.11 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -2.2 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --7DP64HymKb+JCWvF Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Dave, * Dave Johansen (davejohansen@gmail.com) wrote: > So will pg_basebackup keep copying the new data that is added over the > weekend until I tell it to stop? If so, then on Monday, can I close things > down, wait for the WAL to finish, swap the roles of the 2 server and then > restart? No, pg_basebackup will take a snapshot of the current system, essentially. You can set up the new system to connect to the current system, using recovery.conf, to pull the WAL records and apply them to the new server. Thanks! Stephen --7DP64HymKb+JCWvF Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJWtQwgAAoJEO1sijiDR2RVvd8P/1yQMqqDU4D/wktrwFcYQDpB sVq2ha2EATSRMZeEXLvW1qDArgMXuvhWuY9W0OfGxwbcrTTAILejzI0JkqjBemSI ZkjM/pcSDfjrngL2cDRwF/hawppWVgXaLaL2kIJHShYYxRZJa2OeWQ3cJgTJUsa2 AfB3QeDCRcFfuYYKHURmWfqaopgezKti11d6Us0L6Q0Jm0ztwNfMZ7sAWYq0ZoQD g7pLfSgcbT6awIFRjoKZud4h5GTZ/8Lq1VvOJqFlPgRWyFWz1Kv1CpPrk4g0CszJ RInXIKbfC1g+nSXGR+TygB5/7uqbYVzMSq7gRlCYqwWs+FoTAh2C3Q0hYnxf7ZDv IT5RUb+WVJ+9yqZjhsOVUWMiJKz9hk0Vunf7SGLanpMcwWr0bJLc4uN+TE/A2N7m vXNYnhDwEK/fo/FjVZ1K+UoX9F7sZOJmkuCZyXVVlq32q8OJEiBpXj1UmvFCqoFj SdmriikO5cqk6vdEzwdAMr7uCYFnvqlFM9PPHDXABtwXijho79wJl4gX90R/uEkz B2UM/eEvsfGvi27fAwWaCcr2iWbsFZY30dMRG8mqMHDRKS4GIp7UGSoNqgRom6uh iMKqq9VVfdN9q5wNR9RtLqbLa6qsz6p/1Vzho9GzgfdjYc09fyDZkRz6Dc3n1WgQ JwAVvwVf+ajID6OTqHTy =dq9k -----END PGP SIGNATURE----- --7DP64HymKb+JCWvF--