Skip site navigation (1) Skip section navigation (2)

Re: Restore db with multi-tablespaces

From: Rural Hunter <ruralhunter(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Restore db with multi-tablespaces
Date: 2012-09-10 07:00:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

于 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:

In response to

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2012-09-10 17:06:10
Subject: Re: Upgrading from 9.1.2 to 9.1.5
Previous:From: Craig JamesDate: 2012-09-08 20:52:14
Subject: Re: Upgrading from 9.1.2 to 9.1.5

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group