Re: db cluster location - Mailing list pgsql-general

From Scott Frankel
Subject Re: db cluster location
Date
Msg-id 719BC873-7326-4F4C-84F1-509CAC5DE69B@circlesfx.com
Whole thread Raw
In response to Re: db cluster location  (Thomas Kellerer <spam_eater@gmx.net>)
List 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>











pgsql-general by date:

Previous
From: Alan Millington
Date:
Subject: Error "invalid byte sequence for encoding UTF8" on insert into BYTEA column
Next
From: Kynn Jones
Date:
Subject: Re: ISO guidelines/strategies to guard injection attacks