pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Brian C. Doyle <bcdoyle@mindspring.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Alternate Database Locations
Date: Thu, 26 Oct 2000 11:21:44 -0400
Message-ID: <5755.972573704@sss.pgh.pa.us> (raw)
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>

"Brian C. Doyle" <bcdoyle@mindspring.com> 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



view thread (12+ messages)  latest in thread

Message-ID: <5755.972573704@sss.pgh.pa.us>
Permalink:  ../5755.972573704@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/5755.972573704@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us, bcdoyle@mindspring.com
  Subject: Re: Alternate Database Locations
  In-Reply-To: <5755.972573704@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox