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 docs list 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