X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 594F59DCC84 for ; Tue, 29 Nov 2005 15:35:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20243-08 for ; Tue, 29 Nov 2005 15:35:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ahab.skio.peachnet.edu (ahab.skio.peachnet.edu [168.20.254.11]) by postgresql.org (Postfix) with ESMTP id 9F23F9DCCA6 for ; Tue, 29 Nov 2005 15:35:23 -0400 (AST) Received: from skio.peachnet.edu (sprat.skio.peachnet.edu [168.20.2.26]) by ahab.skio.peachnet.edu (8.12.10/8.12.10) with ESMTP id jATJZC7I014238 for ; Tue, 29 Nov 2005 14:35:12 -0500 (EST) Message-ID: <438CAD70.4050005@skio.peachnet.edu> Date: Tue, 29 Nov 2005 14:35:12 -0500 From: Colton Smith User-Agent: Mozilla/5.0 (X11; U; SunOS sun4u; en-US; rv:1.4) Gecko/20040414 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: pg_dump, pg_restore and tablespaces Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-SkIO-MailScanner-Information: Please contact the ISP for more information X-SkIO-MailScanner: Found to be clean X-MailScanner-From: smith@skio.peachnet.edu X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/30 X-Sequence-Number: 19750 Hi: Let's say I have a database comprised of tables scattered over several tablespaces. Suppose I need to move the database to another server and I can't use the same pathnames for the tablespaces. Am I out of luck when it comes to using pg_dump and pg_restore? Thanks!