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 99B5C3B6FC4 for ; Thu, 16 Dec 2004 16:14:16 +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 31105-08 for ; Thu, 16 Dec 2004 16:14:07 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 0A0073CB019 for ; Thu, 16 Dec 2004 16:14:06 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id iBGGE0ZC025123; Thu, 16 Dec 2004 11:14:00 -0500 (EST) To: Peter Eisentraut Cc: "Iain" , pgsql-admin@postgresql.org Subject: Re: easy one: location of the database cluster In-reply-to: <200412161521.17150.peter_e@gmx.net> References: <000801c4e34c$f3572210$7201a8c0@mst1x5r347kymb> <200412161521.17150.peter_e@gmx.net> Comments: In-reply-to Peter Eisentraut message dated "Thu, 16 Dec 2004 15:21:17 +0100" Date: Thu, 16 Dec 2004 11:14:00 -0500 Message-ID: <25122.1103213640@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/164 X-Sequence-Number: 15750 Peter Eisentraut writes: > Iain wrote: >> Is there a "standard" directory that people tend to use for this, >> such as /var/local/pgsql/ ? > According to the Filesystem Hierarchy Standard, program data should be > under /var/lib/. Indeed, many binary distributions use > some variant of that as data directory location. The RPM distributions of PG use /var/lib/pgsql/data as the standard PGDATA value. I'm not sure what Debian does but I think it might be different. Also there has been some talk of including the major release number (7.4, 8.0, etc) in the standard PGDATA value, to ease migration across server versions by allowing different versions to be installed concurrently. regards, tom lane