From: | girish R G peetle <giri(dot)anamika0(at)gmail(dot)com> |
---|---|
To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: File System based PostgreSQL Database server restore to a different mount point. |
Date: | 2014-11-04 10:16:53 |
Message-ID: | CAKKd065mUGScfsyJvFaW25cepi1sE2P9Cp84K9mOwxgF1OAZeQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)albe(at)wien(dot)gv(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2014-11-04 11:19:31 | Re: File System based PostgreSQL Database server restore to a different mount point. |
Previous Message | Albe Laurenz | 2014-11-04 08:46:55 | Re: File System based PostgreSQL Database server restore to a different mount point. |