Re: problem with maintenance script and missing pg_clog files with pg 7.2.1

On Wed, Sep 25, 2002 at 02:12:28PM +0100, Oliver Elphick wrote:

> On Wed, 2002-09-25 at 11:18, Ben Roberts wrote:
> > Or is just 'OK' to have separate directories for POSTGRES_HOME and
> > POSTGRES_DATA?
>
> Yes.
>
> As delivered, the package (postgresql-client, on which postgresql
> depends) installs /etc/postgresql/postgresql.env and sources that in the
> startup script for postgres (one of ~postgres/.profile,
> ~postgres/.bash_profile, ~postgres/.login). postgresql.env is used to
> set up the environment for anyone using psql as well as for postgres.
> It says:
>
> [ -r /etc/postgresql/postmaster.conf ] &&
> . /etc/postgresql/postmaster.conf
>
> PGDATA=${POSTGRES_DATA:-/var/lib/postgres/data}
> ...
>
> POSTGRES_HOME is in fact only used by the install scripts and as the
> directory to cd to before running pg_ctl to start the postmaster. So
> unless you have something in ~postgres/ that is giving PGDATA a
> different value, I can't see any problem here. Even if that were the
> case, the postmaster would be started with one value or the other; I
> don't see how it could use both at once.

Thanks Oliver, that's very useful. Unfortunately in that case I am back to
square #1 in terms of my understanding of this problem.

I can't find anything else that is strange or unusaul about our set up, with
the exception that the DB has been set up to use UNICODE, but that shouldn't
be a problem, should it?

thanks,

Ben