| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Mike Mascari <mascarm(at)mascari(dot)com> |
| Cc: | newsreader(at)mediaone(dot)net, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: createdb confusion |
| Date: | 2001-08-09 02:18:47 |
| Message-ID: | 21167.997323527@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Mike Mascari <mascarm(at)mascari(dot)com> writes:
> How about:
> export PGDATA2=/opt/postgres/data
> initlocation PGDATA2
> createdb -D PGDATA2 mydb
Note also that the environment variable PGDATA2 must be defined in the
*postmaster*'s environment, not only your shell environment. This is
a crude (and ugly) way of letting the DBA control which directories may
be used as alternate locations --- only what he's listed in the
postmaster's environment may be used.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Allan Engelhardt | 2001-08-09 06:36:10 | Re: Re: First Saturday and Last Saturday of a month |
| Previous Message | Yusron Hilmy | 2001-08-09 02:17:18 | getting result information of DECLARE CURSOR statement |