Re: Restore db with multi-tablespaces

Поиск
Список
Период
Сортировка
От Sergey Konoplev
Тема Re: Restore db with multi-tablespaces
Дата
Msg-id CAL_0b1v3DiEhRXTzmCiPTmu3ZO1Wkcve=Y7P1X=X8tcKM2hiVg@mail.gmail.com
обсуждение исходный текст
Ответ на Restore db with multi-tablespaces  (Rural Hunter <ruralhunter@gmail.com>)
Ответы Re: Restore db with multi-tablespaces  (Rural Hunter <ruralhunter@gmail.com>)
Список pgsql-admin
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



--
Sergey Konoplev

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

Jabber: gray.ru@gmail.com Skype: gray-hemp Phone: +79160686204


В списке pgsql-admin по дате отправления:

Предыдущее
От: Rural Hunter
Дата:
Сообщение: Restore db with multi-tablespaces
Следующее
От: Sergey Konoplev
Дата:
Сообщение: Re: Upgrading from 9.1.2 to 9.1.5