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(at)brave(dot)cs(dot)uml(dot)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(dot)Elphick(at)lfix(dot)co(dot)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