Received: from loreal.com ([209.67.1.214]) by hub.org (8.9.2/8.9.1) with SMTP id TAA66749 for ; Sat, 13 Feb 1999 19:14:11 -0500 (EST) (envelope-from fabrice.scemama@gesnet.net) Received: from gesnet.net [164.138.190.144] by loreal.com [127.0.0.1] with SMTP (MDaemon.v2.7.SP4.R) for ; Sat, 13 Feb 1999 19:11:39 -0500 Sender: gesnet Message-ID: <36C61625.624E56A6@gesnet.net> Date: Sun, 14 Feb 1999 00:17:41 +0000 From: Fabrice Scemama Organization: GESNET Consulting X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.2.0-final i586) X-Accept-Language: en MIME-Version: 1.0 To: "Tim Perdue, Directricity.com" CC: pgsql-sql@hub.org Subject: Re: [SQL] Moving Database -> New Disk References: <002a01be570b$b0bd10f0$0b8c5aa5@timnt.weather.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-MDaemon-Deliver-To: pgsql-sql@hub.org X-Return-Path: fabrice.scemama@gesnet.net What about using a symlink ? mv /usr/local/pgsql /fireball ln -s /fireball/pgsql /usr/local/pgsql Should do the whole trick. Fabrice "Tim Perdue, Directricity.com" wrote: > > I'm trying to do somethat that shouldn't be so darn difficult - moving a > database to a new bigger disk. > > The database is db_domain at /usr/local/pgsq/data/base/db_domain > > I want it to reside on /fireball/pgsql/... > > I created a dump of db_domain and was able to do initdb on the new > location - but when I try to createdb, of course db_domain is already taken. > If I try to createdb using the -D switch I get an error about it not being > able to find the directory (it's there). > > If I don't specify the -D switch, any new database is created under > /usr/local/pgsql/data/base/, even though I restarted postmaster with -D > pointing to /fireball/pgsql/.... > > So Could someone give some specific instructions on moving db_domain over to > the new hard disk? If there's a FAQ please give a full URL to find it. > > Tim