Received: from slip3.raccoon.com (slip3.raccoon.com [165.90.134.130]) by hub.org (8.9.2/8.9.1) with ESMTP id XAA66058 for ; Fri, 12 Feb 1999 23:47:50 -0500 (EST) (envelope-from tim@directricity.com) Received: from timnt (tim.desmoinesnet.com [165.90.140.11]) by slip3.raccoon.com (8.8.7/8.8.7) with SMTP id WAA07422 for ; Fri, 12 Feb 1999 22:53:23 -0600 Message-ID: <002a01be570b$b0bd10f0$0b8c5aa5@timnt.weather.net> From: "Tim Perdue, Directricity.com" To: Subject: Moving Database -> New Disk Date: Fri, 12 Feb 1999 22:45:32 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 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