easy one: location of the database cluster - Mailing list pgsql-admin

From Iain
Subject easy one: location of the database cluster
Date
Msg-id 000801c4e34c$f3572210$7201a8c0@mst1x5r347kymb
Whole thread Raw
Responses Re: easy one: location of the database cluster
List pgsql-admin
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


pgsql-admin by date:

Previous
From: "Iain"
Date:
Subject: Re: Tyan Thunder MB for postgres server
Next
From: Sam Mortimer
Date:
Subject: robust way of moving tables to a different disk??