Re: Problem with pg_hba.conf file in Postgres 7.3

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.

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

April Carvalho

On Fri, 23 Jan 2004, Oliver Elphick wrote:

> On Fri, 2004-01-23 at 17:02, Tom Lane wrote:
> > April Carvalho <acarvalh@brave.cs.uml.edu> writes:
> > > It's (PostgreSQL) 7.3.4, from the Debian testing suite.
> > > The syntax is right, but my co worker found out what was wrong--
> > > The files seem to be in the wrong place, and thus they couldn't be
> > > parsed.
> >
> > > The docs say they should be in the same directory as pg_hba.conf,
> > > but they're now in /var/lib/postgres/data (our pg_hba.conf file is
> > > in /etc/postgresql).
> >
> > Hmm.  I would call that a bug in the Debian distribution.  All those
> > files are kept in $PGDATA in a stock Postgres installation.  The Debian
> > version patches things to keep pg_hba.conf in /etc, but evidently has
> > overlooked the possibility of @-included files.  Oliver?
>
> In accordance with Debian policy, pg_hba.conf and the other
> configuration files are in /etc/postgresql; there are symlinks to
> $PGDATA.  I do not change where the program looks for them (in other
> words, it still expects to find them in $PGDATA), so this does not seem
> a likely explanation.  Are permissions OK?  Is PGDATA set to
> /var/lib/postgres/data ?  Or does the user's description above mean that
> the included files were in /etc/postgresql (where the program would not
> look for them) and have now been moved to $PGDATA?
>
> Since the PostgreSQL version is 7.3.4, the question remains whether the
> file inclusion mechanism is even supported.  Can someone answer that
> before I go looking for bugs in the Debian packaging?
>
> --
> 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
>                  ========================================
>      "Look not every man on his own interests, but every man
>       also on the things of others. Let this mind be in you,
>       which was also in Christ Jesus"
>                                 Philippians 2:4,5
>