From: Iain <iain@mst.co.jp>
To: pgsql-admin@postgresql.org
Subject: Re: easy one: location of the database cluster
Date: Fri, 17 Dec 2004 11:02:35 +0900
Message-ID: <00c701c4e3dc$7da40cf0$7201a8c0@mst1x5r347kymb> (raw)
References: <20041216180246.54806.qmail@web12701.mail.yahoo.com>
Hi,
Looks like I should get to know the "Filesystem Hierarchy Standard" atleast
a little better.
>> 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.
This is partly my concern also. It's only a concern for me because I don't
have any direct experience of managing and upgrading production systems
using packages, I have always used the source code download. Backing up your
databases before an upgrade is always advisable, but on the other hand, we
typically don't want to have to endure a restore just because we messed up a
minor upgrade. if you are building from source it's no problem as you just
don't run initdb. As to package upgrades, presumably they don't touch your
data. I have to write a manual for the maintenance and updating of the
server, so I'm gonna have to test it all anyway.
Getting back to my original question (as I think it was) I havn't seen any
reason not to use the default data directory used by the package, especially
if it conforms with the above mentioned standard.
Regards
Iain
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: iain@mst.co.jp
Subject: Re: easy one: location of the database cluster
In-Reply-To: <00c701c4e3dc$7da40cf0$7201a8c0@mst1x5r347kymb>
References: <20041216180246.54806.qmail@web12701.mail.yahoo.com> <00c701c4e3dc$7da40cf0$7201a8c0@mst1x5r347kymb>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox