X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 235133B668E for ; Thu, 16 Dec 2004 08:55:04 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58643-02 for ; Thu, 16 Dec 2004 08:54:56 +0000 (GMT) Received: from millenium.mst.co.jp (unknown [210.230.185.241]) by svr1.postgresql.org (Postfix) with ESMTP id C73023B6677 for ; Thu, 16 Dec 2004 08:54:57 +0000 (GMT) Received: from mst1x5r347kymb (lc12114 [192.168.1.114]) by millenium.mst.co.jp (8.11.6p2/3.7W) with SMTP id iBG8suZ03973 for ; Thu, 16 Dec 2004 17:54:56 +0900 Message-ID: <000801c4e34c$f3572210$7201a8c0@mst1x5r347kymb> From: "Iain" To: Subject: easy one: location of the database cluster Date: Thu, 16 Dec 2004 17:55:05 +0900 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-2022-jp"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/155 X-Sequence-Number: 15741 Hi All, I'm in the process of putting together some docs for a new postgres server. For development use, I've always just been content to have the PGDATA directory as a subdirectory of the main postgres install directory which is /usr/local/pgsql/ by default (when installing from source anyway). My question is whether there is any good reason not to do that in a production environment (for example upgrade time)? Is there a "standard" directory that people tend to use for this, such as /var/local/pgsql/ ? Even if there are no standards, I do like to follow conventions where they exist, since I don't expect to be around by the time this system will be requiring it's first round of maintenance ;-) OS is (will most probably be) RHEL3 Cheers Iain