Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eEu5O-0005Yv-NL for pgsql-admin@arkaria.postgresql.org; Wed, 15 Nov 2017 09:34:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1eEu5O-0003ky-Ab for pgsql-admin@arkaria.postgresql.org; Wed, 15 Nov 2017 09:34:22 +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 1eEu3T-0007ye-Rp for pgsql-admin@postgresql.org; Wed, 15 Nov 2017 09:32:24 +0000 Received: from truschnigg.info ([78.46.103.228]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eEu3Q-00042l-Qn for pgsql-admin@postgresql.org; Wed, 15 Nov 2017 09:32:22 +0000 Received: from vault.lan (84-112-34-152.cable.dynamic.surfer.at [84.112.34.152]) (Authenticated sender: colo) by truschnigg.info (Postfix) with ESMTPSA id 08DF8400F7; Wed, 15 Nov 2017 10:32:18 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=truschnigg.info; s=mail; t=1510738338; bh=dT7eLC3TnGIM4qucc9KfMoN//xTPAHd4zahNrHI/Wcw=; h=Date:From:To:Cc:Subject:References:In-Reply-To:From; b=vifv8t9zvmVP6o4jZswxarONS1XXJp+ClKt51w33w8+ivyGgj6MYfSgeJtbWfirpX 3qhXcHGn35ixnU3otkibrbJ5J0GR4qPaonHFOTB5p3/zBdYTfL4DAlCoy/c5UtMYd7 x3/Fb1l3dccOMz7X4LhQ13l0+8BoSWLIObyXckN4= Date: Wed, 15 Nov 2017 10:32:16 +0100 From: Johannes Truschnigg To: Mark Steben Cc: pgsql-admin Subject: Re: recreating point-in-time recovery when tables are in non-default tablespace Message-ID: <20171115093215.nmix4fnqiccdi6jp@vault.lan> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="qwtreylwvotoykw4" Content-Disposition: inline In-Reply-To: User-Agent: NeoMutt/20170113 (1.7.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 --qwtreylwvotoykw4 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Nov 14, 2017 at 02:54:06PM -0500, Mark Steben wrote: > Good afternoon, >=20 > I have in the past been successful in creating a hot standby environment = as > all my tables were in one cluster on one disk. The base backup (I used ta= r) > easily copied all tables and then the tar extract easily restored them on > our standby server. [...] Why don't you use pg_basebackup instead? It will take care of the gory deta= ils and also handles tablespaces and tablespace mapping for you. --=20 with best regards: - Johannes Truschnigg ( johannes@truschnigg.info ) www: https://johannes.truschnigg.info/ phone: +43 650 2 133337 xmpp: johannes@truschnigg.info Please do not bother me with HTML-email or attachments. Thank you. --qwtreylwvotoykw4 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEGu9IhkI+7/aKLUWF95W3jMsYfLUFAloMCZsACgkQ95W3jMsY fLXuOw/9E001tkM1lX1krdc3aUQZfcqsjuY2yN/BN7l9QKkL9PnEDhV15Tr8G71/ bqitRbv5L8XavDkygtWo4lK8cO6fNWKtpcvFV6mT06J+CsCdkIB8pR/kNfKjW17V DkAEbq4cFmeRYQ1Dii0HZetwvY3T7gTi0V0qiGVDKVEyJxJeHVcmizNdNfM0NXf2 uLzK3VLznu1ydWwUYs0SxKQEFxyYkW/MLErMaPt2b8nA7w9MAf+JgvVCMfVQV0u0 ZypAW4e1lCBLIuwj/dV/+/WBfXXR3ZNG9slAGuWHL4vtejrGvsTYrA31yQMngU5/ /igCQFO33JDdYyKV3myStvC01kl8FvHRtZdm8+ZzFaF3YOyXQG7f9zeJVs/F3BpG CBQYLbchhSHa33qWehjzdOs9aRPLKYPmQoiKh9FFLTh1FBeeEIdM8nA/aBmC9Tod 719Br7dzb3mWN0LQ/4FVzQomtzgZLmDFNcqdgeEgTMUP4SFD2Ko6EKzT1b4QdfiU aF0Rh6sBHFr0DU7DoShPg4d+ZpHOLndwidUBpLCYOJCRDQeN50MaOhaKbG0AKIGL 3pQs84rc9qG8H4UENAMX4k6pWath8dGC7lN1utPPMPliZ+s1fuwdIBpZTiAnUZg2 nzGrUzvZ4onSOGpO8WcuMKtJ5XrO7LW8hnv1FpNCxtYdKtLXvik= =UW/7 -----END PGP SIGNATURE----- --qwtreylwvotoykw4--