Re: Problem with pg_hba.conf file in Postgres 7.3

Yes, that would help.  <feeling stupid>

The files in question were the ones referenced in pg_hba.conf:

host       db1  @db1_users          10.0.0.0   255.255.255.0    md5

There are actually several lines (and several user lists) in this file.
Files like @db1_users, were in /etc/postgresql/, since pg_hba.conf was
there. This made sense at the time, because, according to the postgres
docs, they should be in the same folder as pg_hba.conf.
However, the debian package has $PGDATA/pg_hba.conf has a link
to /etc/postgresql/pg_hba.conf.  Postgres is probably expecting
pg_hba.conf to be in $PGDATA, and Debain expects it in /etc/postgresql.
If I knew nothing of Debian, perhaps this wouldn't have happened.

Funny huh?

Btw, the $PGDATA variable *was* set after all, but just for user postgres.

Thanks for all your help.

April

On Mon, 26 Jan 2004, Oliver Elphick wrote:

> 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
>