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 4393D9DD61C for ; Tue, 6 Dec 2005 16:35:16 -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 83145-05 for ; Tue, 6 Dec 2005 16:35:16 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id AFAD59DCCB8 for ; Tue, 6 Dec 2005 16:11:22 -0400 (AST) Received: by flake.decibel.org (Postfix, from userid 1001) id E16191529C; Tue, 6 Dec 2005 14:11:23 -0600 (CST) Date: Tue, 6 Dec 2005 14:11:23 -0600 From: "Jim C. Nasby" To: Colton Smith Cc: pgsql-admin@postgresql.org Subject: Re: pg_dump, pg_restore and tablespaces Message-ID: <20051206201123.GF16053@nasby.net> References: <438CAD70.4050005@skio.peachnet.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <438CAD70.4050005@skio.peachnet.edu> X-Operating-System: FreeBSD 4.11-RELEASE-p10 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.9i 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/41 X-Sequence-Number: 19761 On Tue, Nov 29, 2005 at 02:35:12PM -0500, Colton Smith wrote: > 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? No. You can just create the tablespaces you need with whatever mapping suits the new server before doing the restore. This will generate an error during the restore (tablespace already exists), but you can ignore that. Just make sure the names match up. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461