From: | Scott Frankel <frankel(at)circlesfx(dot)com> |
---|---|
To: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: db cluster location |
Date: | 2010-01-21 20:48:03 |
Message-ID: | 719BC873-7326-4F4C-84F1-509CAC5DE69B@circlesfx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kynn Jones | 2010-01-21 21:53:44 | Re: ISO guidelines/strategies to guard injection attacks |
Previous Message | Alan Millington | 2010-01-21 19:54:32 | Error "invalid byte sequence for encoding UTF8" on insert into BYTEA column |