Red Hat Bugzilla – Bug 68363
Unable to change PGDATA in postgres
Last modified: 2007-04-18 12:44:00 EDT
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.1a) Gecko/20020610
Description of problem:
The way postgresql is currently packaged it is hard to change the location of
the database (i.e. PGDATA) without modifying the startup script (which will get
overwritten on updating).
A better way of setting PGDATA (rather than fixing it to /var/lib/pgsql) would
be to see what the home directory of the postgres user is set to and use that.
If you have a nice, clean patch which doesn't lead to problems for initscripts,
file ownership etc, you can attact it.
Other than that, I don't see a need and the current way works well - and handles
issues like recognizing older versions of the database and issueing approriate