Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T9rNC-0008RN-7k for pgsql-admin@postgresql.org; Fri, 07 Sep 2012 05:44:58 +0000 Received: from mail-pb0-f46.google.com ([209.85.160.46]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T9rN9-0002jn-V6 for pgsql-admin@postgresql.org; Fri, 07 Sep 2012 05:44:57 +0000 Received: by pbbrr13 with SMTP id rr13so3528167pbb.19 for ; Thu, 06 Sep 2012 22:44:55 -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 :content-type:content-transfer-encoding; bh=OXOm1fyMLSWBQQHXH3ehwEq9hTjrWj4a7krJUY9N6Kc=; b=XD6A/7cAsRBYJ20CS/g6h83X7jxgPyBwAgG4QfXCgkHSijgdUJDYi4+S9ynAb7tOqk dvhMe599n2xnzumAc6XE+tk0btTw1fHtHW2QzrsW1lgvVOtfwyOfycZISra9EntE/QPc hmUNubU/nO1XglR9E89UMNIB4hT5QO3hUboU+HHiEw8d8SqFQTYITRc0oGIaXnqoOHFi EHNAW2RKHZP6PTNRJVyiC3xvzj1frG1wXMO8bntZ3FRvbdyNVAzs3zu8u0JZvuYqXWIo vpC7KJTELC7qhqL8nztbWRoyAOJjfmEl2MHXUzQCU5ITbCaW8XwaRQ4hw+WyudHPswlm +V4w== Received: by 10.66.76.165 with SMTP id l5mr6989326paw.79.1346996694968; Thu, 06 Sep 2012 22:44:54 -0700 (PDT) Received: from [192.168.1.9] ([116.226.32.153]) by mx.google.com with ESMTPS id kt2sm2548489pbc.73.2012.09.06.22.44.52 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 06 Sep 2012 22:44:53 -0700 (PDT) Message-ID: <504989D1.4080508@gmail.com> Date: Fri, 07 Sep 2012 13:44:49 +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: Restore db with multi-tablespaces Content-Type: text/plain; charset=GB18030; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201209/27 X-Sequence-Number: 39968 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?