Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TAxzZ-0007Hs-P4 for pgsql-admin@postgresql.org; Mon, 10 Sep 2012 07:01:09 +0000 Received: from mail-pb0-f46.google.com ([209.85.160.46]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TAxzW-0005IM-Tb for pgsql-admin@postgresql.org; Mon, 10 Sep 2012 07:01:09 +0000 Received: by pbbrr13 with SMTP id rr13so2014815pbb.19 for ; Mon, 10 Sep 2012 00:01:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; bh=DmKMeR3ZZ8f+LhlGUqvas+j+fzttQhBNtjed7kPPLFU=; b=ReIZjldpgJzLpBIBIy34p0i2jXQI57jdjZ2AusZaG3S7YBljxAOLoUHGPOX26LKImh lt4pwV6pl2Csk/VwqoL65jOllmVqXyGtbdRgNrBCaKG1pSY9FYxWmtoQEkH5lg8vbQUi LRAFWud9fyfjV3JG37nwpPQEB56RKGgzLNF5/v6e2GHwCIs6YaQwt5bE0GHKEiRV9BCC sMj0ysP8WirCYHCb2qc1PsYqgWHNv3YqvDiYnLzrTo5Q7Hi+tpbX9SvWEBGZ74IpHWkx ulgZ/2p+SF/FM5dz44av8OaIr5rpZs6kjkEcneXqKtZlwfrZx4YKjXstpbI4WWDk5bLj mGzQ== Received: by 10.68.237.3 with SMTP id uy3mr4671281pbc.30.1347260464950; Mon, 10 Sep 2012 00:01:04 -0700 (PDT) Received: from [192.168.1.8] ([116.226.32.153]) by mx.google.com with ESMTPS id hc10sm7619484pbc.21.2012.09.10.00.01.01 (version=TLSv1/SSLv3 cipher=OTHER); Mon, 10 Sep 2012 00:01:03 -0700 (PDT) Message-ID: <504D902A.7030906@gmail.com> Date: Mon, 10 Sep 2012 15:00:58 +0800 From: Rural Hunter User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:15.0) Gecko/20120824 Thunderbird/15.0 MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: Re: Restore db with multi-tablespaces References: <504989D1.4080508@gmail.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -2.7 (--) X-Archive-Number: 201209/31 X-Sequence-Number: 39972 Thanks! 于 2012/9/7 20:20, Sergey Konoplev 写道: > On Fri, Sep 7, 2012 at 9:44 AM, Rural Hunter 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 > >