Re: Restore db with multi-tablespaces

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

--
Sergey Konoplev

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

Jabber: gray(dot)ru(at)gmail(dot)com Skype: gray-hemp Phone: +79160686204