Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id EFAAA64FCF7 for ; Fri, 5 Sep 2008 16:11:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 26546-10 for ; Fri, 5 Sep 2008 16:11:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 5691064FCEB for ; Fri, 5 Sep 2008 16:11:45 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m85JBfTI029792; Fri, 5 Sep 2008 15:11:41 -0400 (EDT) To: Carol Walter cc: pgsql-admin@postgresql.org, Dave Cole Subject: Re: Default data directory In-reply-to: References: Comments: In-reply-to Carol Walter message dated "Fri, 05 Sep 2008 14:44:30 -0400" Date: Fri, 05 Sep 2008 15:11:41 -0400 Message-ID: <29791.1220641901@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/50 X-Sequence-Number: 30143 Carol Walter writes: > I can't figure out how the Postgres that's running on the production > web server knows where to look for its data. Generally the location of the data directory is determined by a -D switch on the postmaster command line, or by setting the PGDATA environment variable in the script that launches the postmaster. Setting it in the configuration file would be circular logic, except in the uncommon sort of configuration where the config file doesn't live in the data directory (in which case the -D switch only indicates where the config files are). regards, tom lane