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
On Jan 21, 2010, at 10:00 AM, Scott Frankel wrote:
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
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
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
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