Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id CAE43B5DBC0 for ; Fri, 4 Nov 2011 13:32:29 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 35668-05 for ; Fri, 4 Nov 2011 16:32:18 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from momjian.us (momjian.us [72.94.173.45]) by mail.postgresql.org (Postfix) with ESMTP id B6AFAB5D91F for ; Fri, 4 Nov 2011 13:32:17 -0300 (ADT) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id pA4GWDH15361; Fri, 4 Nov 2011 12:32:13 -0400 (EDT) From: Bruce Momjian Message-Id: <201111041632.pA4GWDH15361@momjian.us> Subject: Re: PGDATA confusion In-Reply-To: To: Thom Brown Date: Fri, 4 Nov 2011 12:32:13 -0400 (EDT) CC: pgsql-docs X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-3.101 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-1.201 X-Spam-Level: X-Archive-Number: 201111/5 X-Sequence-Number: 7080 Thom Brown wrote: > > So if one set PGDATA to somewhere which had no database files at all, > > but just postgresql.conf, it could still work (assuming it, in turn, > > set data_directory correctly), but not vice versa. ?It would make more > > sense to call it PGCONFIG, although I'm not proposing that, especially > > since PGDATA makes sense when it comes to initdb. > > > > There are probably plenty of other places in the docs which also don't > > adequately describe PGDATA or -D. > > > > Any disagreements? ?If not, should I write a patch (since someone will > > probably accuse me of volunteering anyway) or would someone like to > > commit some adjustments? > > No opinions on this? Yes. I had kept it to deal with later. Please work on a doc patch to try to clean this up. pg_upgrade just went through this confusion and I also was unhappy at how vague things are in this area. Things got very confusing with pg_upgrade when PGDATA pointed to the configuration directory and the data_directory GUC pointed to the data directory. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +