Re: Problem with pg_hba.conf file in Postgres 7.3

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