Re: CREATE DATABASE WITH LOCATION

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Glen Parker" <glenebob(at)nwlink(dot)com>
Cc: "Pg-General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: CREATE DATABASE WITH LOCATION
Date: 2001-11-13 22:22:08
Message-ID: 3865.1005690128@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Glen Parker" <glenebob(at)nwlink(dot)com> writes:
> having a little problem with the alternate DB location stuff, on redhat
> 7.2/postgres 7.1.3. 'CREATE DATABASE WITH LOCATION 'PGDATA2' claims that
> PGDATA2 environment not set, although i've defined it in .bash_profile (for
> user posgres) and verified that it takes when i 'su -l postgres'. yes, i
> restarted the postmaster.

Exactly how did you restart the postmaster?

Also, did you remember to "export PGDATA2" from the profile file, not
merely set its value?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-11-13 22:24:35 Re: dropdb to a remote host
Previous Message Command Prompt, Inc. 2001-11-13 22:12:28 Practical PostgreSQL over 5,000 copies already!