Обсуждение: Restore db with multi-tablespaces
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?
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
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 > >