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

Scott Frankel wrote on 21.01.2010 18:34:
>
> Hi all,
>
> Is there a query I can use to find the location of a db cluster?

SELECT name,
        setting
FROM pg_settings
WHERE category = 'File Locations';

You need to be connected as the superuser (usually postgres)

Exactly what I was looking for.  Thanks!




On Jan 21, 2010, at 10:50 AM, Thomas Kellerer wrote:

> Scott Frankel wrote on 21.01.2010 18:34:
>>
>> Hi all,
>>
>> Is there a query I can use to find the location of a db cluster?
>
> SELECT name,
>       setting
> FROM pg_settings
> WHERE category = 'File Locations';
>
> You need to be connected as the superuser (usually postgres)
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>