From: Rural Hunter <ruralhunter@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Restore db with multi-tablespaces
Date: Mon, 10 Sep 2012 15:00:58 +0800
Message-ID: <504D902A.7030906@gmail.com> (raw)
In-Reply-To: <CAL_0b1v3DiEhRXTzmCiPTmu3ZO1Wkcve=Y7P1X=X8tcKM2hiVg@mail.gmail.com>
References: <504989D1.4080508@gmail.com>
<CAL_0b1v3DiEhRXTzmCiPTmu3ZO1Wkcve=Y7P1X=X8tcKM2hiVg@mail.gmail.com>
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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ruralhunter@gmail.com
Subject: Re: Restore db with multi-tablespaces
In-Reply-To: <504D902A.7030906@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox