Thread: db cluster location

Hi all,

Is there a query I can use to find the location of a db cluster?

I've found a term that looks promising (\d+ pg_database;), but can't
seem to tease a directory path from it.  The docs list several common
locations, but mine doesn't appear to be one of them.

Searching my local file system for "data" yields too many hits for
that approach to be useful.

I installed pg via Macports.

Thanks in advance!
Scott

On Jan 21, 2010, at 10:00 AM, Scott Frankel wrote:

>
> Hi all,
>
> Is there a query I can use to find the location of a db cluster?
>
> I've found a term that looks promising (\d+ pg_database;), but can't seem to tease a directory path from it.  The
docslist several common locations, but mine doesn't appear to be one of them. 

"show data_directory" is probably what you're looking for.

(also useful:  "show config_file", "show hba_file", "show ident_file").

Cheers,
  Steve