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:
Show quoted text
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