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