pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRestore db with multi-tablespaces
3+ messages / 2 participants
[nested] [flat]
* Restore db with multi-tablespaces
@ 2012-09-07 05:44 Rural Hunter <ruralhunter@gmail.com>
2012-09-07 12:20 ` Re: Restore db with multi-tablespaces Sergey Konoplev <gray.ru@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Rural Hunter @ 2012-09-07 05:44 UTC (permalink / raw)
To: pgsql-admin
Hi,
I have a database with several tablespaces on different disks and
backup-ed it with pg_basebackup. I have theses files:
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?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Restore db with multi-tablespaces
2012-09-07 05:44 Restore db with multi-tablespaces Rural Hunter <ruralhunter@gmail.com>
@ 2012-09-07 12:20 ` Sergey Konoplev <gray.ru@gmail.com>
2012-09-10 07:00 ` Re: Restore db with multi-tablespaces Rural Hunter <ruralhunter@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Sergey Konoplev @ 2012-09-07 12:20 UTC (permalink / raw)
To: Rural Hunter <ruralhunter@gmail.com>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Restore db with multi-tablespaces
2012-09-07 05:44 Restore db with multi-tablespaces Rural Hunter <ruralhunter@gmail.com>
2012-09-07 12:20 ` Re: Restore db with multi-tablespaces Sergey Konoplev <gray.ru@gmail.com>
@ 2012-09-10 07:00 ` Rural Hunter <ruralhunter@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Rural Hunter @ 2012-09-10 07:00 UTC (permalink / raw)
To: pgsql-admin
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
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-09-10 07:00 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-09-07 05:44 Restore db with multi-tablespaces Rural Hunter <ruralhunter@gmail.com>
2012-09-07 12:20 ` Sergey Konoplev <gray.ru@gmail.com>
2012-09-10 07:00 ` Rural Hunter <ruralhunter@gmail.com>
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