Re: Default data directory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Carol Walter <walterc(at)indiana(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org, Dave Cole <daedcole(at)indiana(dot)edu>
Subject: Re: Default data directory
Date: 2008-09-05 19:11:41
Message-ID: 29791.1220641901@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Carol Walter <walterc(at)indiana(dot)edu> writes:
> I can't figure out how the Postgres that's running on the production
> web server knows where to look for its data.

Generally the location of the data directory is determined by a -D
switch on the postmaster command line, or by setting the PGDATA
environment variable in the script that launches the postmaster.

Setting it in the configuration file would be circular logic,
except in the uncommon sort of configuration where the config file
doesn't live in the data directory (in which case the -D switch
only indicates where the config files are).

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Arctic Toucan 2008-09-05 20:07:20 Re: How can I avoid Frozenxid wraparound on failover to a standby(PITR) database?
Previous Message Tom Lane 2008-09-05 18:45:49 Re: How can I avoid Frozenxid wraparound on failover to a standby(PITR) database?