Received: from granger.mail.mindspring.net (granger.mail.mindspring.net [207.69.200.148]) by hub.org (8.10.1/8.11.0) with ESMTP id e9PJLsO95521 for ; Wed, 25 Oct 2000 15:21:54 -0400 (EDT) (envelope-from bcdoyle@mindspring.com) Received: from hbg-dnt-1467.mindspring.com (fw-5-e3.atl2.mindspring.net [207.69.162.92]) by granger.mail.mindspring.net (8.9.3/8.8.5) with ESMTP id PAA05904; Wed, 25 Oct 2000 15:21:48 -0400 (EDT) Message-Id: <5.0.0.25.2.20001025151441.088d35d0@pop.mindspring.com> X-Sender: bcdoyle@pop.mindspring.com X-Mailer: QUALCOMM Windows Eudora Version 5.0 Date: Wed, 25 Oct 2000 15:20:29 -0400 To: "Roderick A. Anderson" From: "Brian C. Doyle" Subject: Re: Alternate Database Locations Cc: pgsql-sql@postgresql.org In-Reply-To: References: <4.3.2.7.2.20001024190037.00e2fa80@pop.mindspring.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200010/220 X-Sequence-Number: 1884 Well I got it working kinda. You have set up an environment for the new directory and export it under the PGSQL super user account PGDATA2=/home/userid export PGDATA2 Then run initlocation PGDATA2 After that you have to restart your postmaster with the data dir as PGDATA2 postmaster -d PGDATA2 Now you can greate a new db in a new location createdb mydb -D PGDATA2 that is it and you have a new location for ALL your database if you use it ... If you do not add -D PGDATA2 for future db it writes to the default location but you may have problems access it. I am still trying to find out how to get multiple postmasters running on different ports at the same time. Does anyone have any clue how to do that? At 12:04 PM 10/25/00 -0700, Roderick A. Anderson wrote: >On Tue, 24 Oct 2000, Brian C. Doyle wrote: > > > Never mind... I got it working > >OK, don't play your cards so close to the vest. What was the problem (and >solution)? > > >TIA, >Rod >-- >Roderick A. Anderson >raanders@altoplanos.net Altoplanos Information Systems, Inc. >Voice: 208.765.6149 212 S. 11th Street, Suite 5 >FAX: 208.664.5299 Coeur d'Alene, ID 83814