Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] recreating point-in-time recovery when tables are innon-default tablespace - Mailing list pgsql-admin

From Johannes Truschnigg
Subject Re: [ADMIN] recreating point-in-time recovery when tables are innon-default tablespace
Date
Msg-id 20171115093215.nmix4fnqiccdi6jp@vault.lan
Whole thread Raw
In response to [ADMIN] recreating point-in-time recovery when tables are in non-default tablespace  (Mark Steben <mark.steben@drivedominion.com>)
Responses Re: [ADMIN] recreating point-in-time recovery when tables are innon-default tablespace
List pgsql-admin
Tree view 
On Tue, Nov 14, 2017 at 02:54:06PM -0500, Mark Steben wrote:
> Good afternoon,
>
> 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 tar)
> 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 details
and also handles tablespaces and tablespace mapping for you.

--
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.

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: [ADMIN] recreating point-in-time recovery when tables are innon-default tablespace
Next
From: Laurenz Albe
Date:
Subject: Re: [ADMIN] Vacuum not removing dead tuples