Skip site navigation (1) Skip section navigation (2)

Re: easy one: location of the database cluster

From: <ogjunk-pgjedan(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: easy one: location of the database cluster
Date: 2004-12-16 18:02:46
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Peter Eisentraut <peter_e(at)gmx(dot)net> 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/<packagename>.  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.


In response to


pgsql-admin by date

Next:From: Scott MarloweDate: 2004-12-16 18:05:26
Subject: Re: missing schemas from template1
Previous:From: Tom LaneDate: 2004-12-16 17:59:58
Subject: Re: missing schemas from template1

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group