Re: Restore db with multi-tablespaces

Thanks!

于 2012/9/7 20:20, Sergey Konoplev 写道:
> On Fri, Sep 7, 2012 at 9:44 AM, Rural Hunter <ruralhunter(at)gmail(dot)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(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>
>