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 0E5C03B72C3 for ; Thu, 16 Dec 2004 18:02:57 +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 82302-02 for ; Thu, 16 Dec 2004 18:02:52 +0000 (GMT) Received: from web12701.mail.yahoo.com (web12701.mail.yahoo.com [216.136.173.238]) by svr1.postgresql.org (Postfix) with SMTP id 07DB53B7257 for ; Thu, 16 Dec 2004 18:02:48 +0000 (GMT) Received: (qmail 54808 invoked by uid 60001); 16 Dec 2004 18:02:47 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=RdzVhH0slCPhVe5sqwpW+C76GS8hrgdB/7IoAEiCklYghICijwaQLvaoHKGf0Rx9eIw0TPY2mlDCTLug+ZBIWGX1N4B9qZPuHnKg9PzXSIZf0ySwHaUaRtUDp9rtWIYtm24DfivEloAOZK38Xy/ynaW9jsM0Xwd/9YSm0FPs1HM= ; Message-ID: <20041216180246.54806.qmail@web12701.mail.yahoo.com> Received: from [216.194.17.194] by web12701.mail.yahoo.com via HTTP; Thu, 16 Dec 2004 10:02:46 PST Date: Thu, 16 Dec 2004 10:02:46 -0800 (PST) From: Reply-To: ogjunk-pgjedan@yahoo.com Subject: Re: easy one: location of the database cluster To: pgsql-admin@postgresql.org In-Reply-To: <25122.1103213640@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.552 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200412/181 X-Sequence-Number: 15767 --- Tom Lane wrote: > 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. Oh, this would be excellent! The fear of dealing with 2 different versions and the fear of overwriting something by mistake is what's keeping me from upgrading my PG installation. Otis