Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D2C8C64FD20 for ; Fri, 5 Sep 2008 18:21:22 -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 55162-07 for ; Fri, 5 Sep 2008 18:21:20 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.230]) by postgresql.org (Postfix) with ESMTP id 038E664FD1A for ; Fri, 5 Sep 2008 18:21:19 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so816953rvf.43 for ; Fri, 05 Sep 2008 14:21:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=vmD9WhH6zNcoJiiSYeq4LNxyBtnFXz8XMhB6qx0hQIE=; b=tLq8DT0bmtsKMFLcqMdJS3k3giQXsrL9Gaqmi/KUsB15QVw0S3uRY7v0ukZ4At91N9 PxgPB10k3b8WYvPOMx1Z8Z4Ks+Gd2StLTPjrpLjknBCB+3fuQp1FkGv6bnhYiK7p1Had V/7IXtxVKnC7lfhfue2diPJSCZIgTljp3gkdY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=IzAtw3BujWcJtGmHb2yrvV6Yl/iqQRtqQFVfyz3RdpN17kXqDxd+Q87x3gAAG03E1F 7wdMVRilebH+JJpUi6dbYzzIbEmkiBQlmqmD5H/GBkD5+SX26NcQ6dOwZw3Tagcgw53d y4MHIlZi+k1lJ2b6UkNnK1r9j5uzEpdrYAqHQ= Received: by 10.140.226.14 with SMTP id y14mr6925843rvg.188.1220649678190; Fri, 05 Sep 2008 14:21:18 -0700 (PDT) Received: by 10.141.74.11 with HTTP; Fri, 5 Sep 2008 14:21:18 -0700 (PDT) Message-ID: Date: Fri, 5 Sep 2008 15:21:18 -0600 From: "Scott Marlowe" To: "Carol Walter" Subject: Re: Default data directory Cc: pgsql-admin@postgresql.org, "Dave Cole" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: 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/52 X-Sequence-Number: 30145 On Fri, Sep 5, 2008 at 12:44 PM, Carol Walter wrote: > Hello, > > We're building a test box for our webmaster to play in. It needs to have > the same config as his production box. The postgres default data directory > doesn't match the location of the data directory location on the production > box. The postgresql.conf file has the line that says that it changes the > default data location commented out. Is there somewhere else that postgres > can get this information? > > I can't figure out how the Postgres that's running on the production web > server knows where to look for its data. We don't quite have enough information to really troubleshoot this. What OS, and how was pg installed in each if they're different. If the webmaster needs a sandbox like production, then I would assume the two OSes are the same, right?