Discussion:
Restore db with multi-tablespaces
(too old to reply)
Rural Hunter
2012-09-07 05:44:49 UTC
Permalink
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?
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Sergey Konoplev
2012-09-07 12:20:19 UTC
Permalink
Post by Rural Hunter
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.
Post by Rural Hunter
--
http://www.postgresql.org/mailpref/pgsql-admin
--
Sergey Konoplev

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

Jabber: ***@gmail.com Skype: gray-hemp Phone: +79160686204
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Rural Hunter
2012-09-10 07:00:58 UTC
Permalink
Thanks!
Post by Sergey Konoplev
Post by Rural Hunter
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.
Post by Rural Hunter
--
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Loading...