[rt-users] Debian setup: postgres problem?

[Jens Porup]

On Mon, Jun 28, 2004 at 09:52:55AM +0100, Stephen Quinney wrote:
> On Mon, Jun 28, 2004 at 12:07:49PM +1000, Jens Porup wrote:
> > 
> > But if I tail the logs during the server restart, this line pops up just after
> > the restart finishes:
> > 
> >         root at request-tracker:~# tail -f /var/log/postgresql/postgres.log
> >         ...<snip>...
> >         LOG:  unexpected EOF on client connection
> > 
> > And yes, I do have the correct lines in my /etc/postgresql/pg_hba.conf
> > -- except for that didn't work, for some reason postgres was actually
> > reading my /var/lib/postgres/data/pg_hba.conf instead, so I've symlinked
> > the /etc conf file to the /var/lib file.
> 
> Which version of the Debian postgresql package do you have installed?
> If this is the case it is a bug in the packaging of postgres.
> 
> It sounds to me from your description of the problem that there is
> something odd going on with your pg_hba.conf. Could you reply with all
> the non-comment lines so I can see what you've got there at the
> moment.

Version is:

	root at request-tracker:~# psql --version
	psql (PostgreSQL) 7.4.2
	contains support for command-line editing
	root at request-tracker:~#

and

	root at request-tracker:~# apt-cache show postgresql
	Package: postgresql
	Priority: optional
	Section: misc
	Installed-Size: 9160
	Maintainer: Oliver Elphick <Oliver.Elphick at lfix.co.uk>
	Architecture: i386
	Version: 7.4.2-4
	<...>

	And my pg_hba.conf:

	host    template1   rtuser    127.0.0.1    255.255.255.255   password
	local   template1   rtuser                                   password
	host    rtdb        rtuser    127.0.0.1    255.255.255.255   password
	local   rtdb        rtuser                                   password

	local   all         postgres                                        ident sameuser

	local   all         all                                             ident sameuser
	host    all         all         127.0.0.1         255.255.255.255   ident sameuser
	host    all         all         ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        ident sameuser
	host    all         all         ::ffff:127.0.0.1/128                ident sameuser
	host    all         all         0.0.0.0           0.0.0.0           reject


Thanks for your help, Stephen.

Jens