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

From Rural Hunter
Subject Re: Restore db with multi-tablespaces
Date
Msg-id 504D902A.7030906@gmail.com
Whole thread Raw
In response to Re: Restore db with multi-tablespaces  (Sergey Konoplev <gray.ru@gmail.com>)
List pgsql-admin
Thanks!

于 2012/9/7 20:20, Sergey Konoplev 写道:
> 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
>
>



pgsql-admin by date:

Previous
From: Craig James
Date:
Subject: Re: Upgrading from 9.1.2 to 9.1.5
Next
From: "Kevin Grittner"
Date:
Subject: Re: Upgrading from 9.1.2 to 9.1.5