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