Re: File System based PostgreSQL Database server restore to a different mount point. - Mailing list pgsql-admin

From girish R G peetle
Subject Re: File System based PostgreSQL Database server restore to a different mount point.
Date
Msg-id CAKKd065mUGScfsyJvFaW25cepi1sE2P9Cp84K9mOwxgF1OAZeQ@mail.gmail.com
Whole thread Raw
In response to Re: File System based PostgreSQL Database server restore to a different mount point.  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Responses Re: File System based PostgreSQL Database server restore to a different mount point.
List pgsql-admin
Thanks Laurenz Albe. After adjusting symbolic links should we update table space directory in  'pg_tablespace' system catalog ?

Thanks
Girish

On Tue, Nov 4, 2014 at 2:16 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
girish R G peetle wrote:
> We have requirement to perform File system based restore of entire PostgreSQL database server to a
> different mount point.
>
> -> I know that if no user created tablespaces are involved, we have just need to restore the entire
> DATA directory to new mount point, modify configuration parameters if required and then start the
> server.
> -> If user created table-space directories are involved, then we will have to manually adjust the
> symbolic links (under pg_tblspc) to the new tablespace directory path and bring up the server.
>
> Adjusting symbolic links is a workaround ( hook! ), is there a any official documentation on how
> 'PostgreSQL server restore to a different mount point' can be achieved ?

That should work.
The only documentation is at
http://www.postgresql.org/docs/9.3/static/continuous-archiving.html#BACKUP-PITR-RECOVERY
which mentions tablespaces, but does not discuss your case directly.

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: File System based PostgreSQL Database server restore to a different mount point.
Next
From: Albe Laurenz
Date:
Subject: Re: File System based PostgreSQL Database server restore to a different mount point.