Skip site navigation (1) Skip section navigation (2)

Re: Problem with pg_hba.conf file in Postgres 7.3

From: April Carvalho <acarvalh(at)brave(dot)cs(dot)uml(dot)edu>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-novice(at)postgresql(dot)org>,Dan MacNeil <omacneil(at)brave(dot)cs(dot)uml(dot)edu>
Subject: Re: Problem with pg_hba.conf file in Postgres 7.3
Date: 2004-01-26 20:18:34
Message-ID: Pine.LNX.4.44.0401261515181.25031-100000@brave.cs.uml.edu (view raw or flat)
Thread:
Lists: pgsql-novice
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
>


In response to

Responses

pgsql-novice by date

Next:From: glennDate: 2004-01-26 20:25:56
Subject: Re: Hierarchal data
Previous:From: Tom LaneDate: 2004-01-26 19:59:31
Subject: Re: postgre-7.4 and readline-4.3 /solaris 8

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group