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 doesn't appear to be one of them.
"show data_directory" is probably what you're looking for. (also useful: "show config_file", "show hba_file", "show ident_file"). Cheers, Steve -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
