Re: Restore db with multi-tablespaces - Mailing list pgsql-admin

From Sergey Konoplev
Subject Re: Restore db with multi-tablespaces
Date
Msg-id CAL_0b1v3DiEhRXTzmCiPTmu3ZO1Wkcve=Y7P1X=X8tcKM2hiVg@mail.gmail.com
Whole thread Raw
In response to Restore db with multi-tablespaces  (Rural Hunter <ruralhunter@gmail.com>)
Responses Re: Restore db with multi-tablespaces  (Rural Hunter <ruralhunter@gmail.com>)
List pgsql-admin
On Fri, Sep 7, 2012 at 9:44 AM, Rural Hunter <ruralhunter@gmail.com> wrote:
> base_20120902.tar.gz
> 27781958.tar.gz
> 27781959.tar.gz
>
> Now I want to restore it on another server with only one disk. I'm confused
> how to handle those tablespace files. Is there a guideline or doc for this
> kind of restore?

Unpack base_20120902.tar.gz into the data directory, find pg_tblspc
there and "ls -l" it. You will see symlinks pointing to some
directories. These are where your tablespaces should be located.
Create this directories. Then you will need to determine which archive
(27781958.tar.gz, 27781959.tar.gz) where to unpack. May be you will
find some hints inside these archives or the names of the archives
will be the names of symlinks.

>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin



--
Sergey Konoplev

a database and software architect
http://www.linkedin.com/in/grayhemp

Jabber: gray.ru@gmail.com Skype: gray-hemp Phone: +79160686204


pgsql-admin by date:

Previous
From: Rural Hunter
Date:
Subject: Restore db with multi-tablespaces
Next
From: Sergey Konoplev
Date:
Subject: Re: Upgrading from 9.1.2 to 9.1.5