Re: Problem with pg_hba.conf file in Postgres 7.3

On Mon, 2004-01-26 at 20:18, April Carvalho wrote:
> Btw, thanks for all the help.  :-)
>
> I think that permissions are ok, since it was working fine when
> the files were moved; it would still be broken if the perms were
> not right.

Where were the files when it didn't work, and where did you move them
to?

> However $PGDATA was not set, assuming that the debconf (the debian
> package configuration program) had already set it properly.

In the environment of the 'postgres' login, it should be set.  This is
the user under which the postmaster is (should be) run.  If it weren't
set, the postmaster couldn't start, because it wouldn't know where to
find the database.  If an ordinary user needs it set, he should source
/etc/postgresql/postgresql.env in his .bashrc or other startup script.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Wash me thoroughly from mine iniquity, and cleanse me
      from my sin. For I acknowledge my transgressions; and
      my sin is ever before me. Against thee, thee only,
      have I sinned, and done this evil in thy sight..."
                                   Psalms 51:2-4