Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by hub.org (8.10.1/8.11.0) with ESMTP id e9QFLkU95937 for ; Thu, 26 Oct 2000 11:21:47 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id e9QFLj505758; Thu, 26 Oct 2000 11:21:45 -0400 (EDT) To: "Brian C. Doyle" cc: pgsql-sql@postgresql.org Subject: Re: Alternate Database Locations In-reply-to: <5.0.0.25.2.20001026105038.054c5a90@pop.mindspring.com> References: <5.0.0.25.2.20001026060649.04965e00@pop.mindspring.com> <5.0.0.25.2.20001025151441.088d35d0@pop.mindspring.com> <4.3.2.7.2.20001024190037.00e2fa80@pop.mindspring.com> <5.0.0.25.2.20001025151441.088d35d0@pop.mindspring.com> <5.0.0.25.2.20001026060649.04965e00@pop.mindspring.com> <5.0.0.25.2.20001026105038.054c5a90@pop.mindspring.com> Comments: In-reply-to "Brian C. Doyle" message dated "Thu, 26 Oct 2000 10:56:05 -0400" Date: Thu, 26 Oct 2000 11:21:44 -0400 Message-ID: <5755.972573704@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200010/243 X-Sequence-Number: 1910 "Brian C. Doyle" writes: > createdb user1 -D 'PGDATA2' > it creates but it is putting it in /home/user/database > the first alt location i set up!!! Um, are you sure createdb is connecting to the right postmaster? When you use multiple postmasters you have to keep a close eye on clients' PGPORT settings ... If it is the right postmaster but wrong interpretation of PGDATA2, the odds are that you started that postmaster with the wrong value of PGDATA2. Remember that it's the postmaster's environment, not the client's, in which alternate-DB environment variables are expanded. (initlocation is an exception because it doesn't contact the postmaster) regards, tom lane