Skip site navigation (1) Skip section navigation (2)

Re: Alternate Database Locations

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Brian C(dot) Doyle" <bcdoyle(at)mindspring(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Alternate Database Locations
Date: 2000-10-26 15:21:44
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
"Brian C. Doyle" <bcdoyle(at)mindspring(dot)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

In response to

pgsql-sql by date

Next:From: Stephan SzaboDate: 2000-10-26 15:22:15
Subject: Re: Query Problem
Previous:From: Tom LaneDate: 2000-10-26 15:16:39
Subject: Re: Query Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group