[Pkg-postgresql-public] Postgresql refuse TCP/IP connections

[Michelle Konzack]

Hi *,

I have a running PostgreSQL 7.4 (own backport) under Woody which
works since years...

Now, my Server has three Debian-Installations (rescue, production 1
and production 2) and I had replaced "production 2" with Sarge.

All is working fine except TCP/IP connections...

I get the know error:

----8<--------------------------------------------------------------
[michelle.konzack at michelle1.private:~/] psql --host samba3.private.t
dnet.net --list
psql: FATAL:  no pg_hba.conf entry for host "192.168.0.71", user "mi
chelle.konzack", database "template1", SSL off
----8<--------------------------------------------------------------

Arghhhh...
My "pg_hba.conf" is setup and it is the same as under Woody!

----8<--------------------------------------------------------------
local     all   postgres                              ident sameuser

host      all   all       127.0.0.1         255.255.255.255   md5

host      all   all       0.0.0.0           0.0.0.0           reject

hostssl   all   all       192.168.0.64/192                    md5

hostssl   all   all       192.168.0.71      255.255.255.192   md5
hostssl   all   all       192.168.0.69      255.255.255.192   md5
----8<--------------------------------------------------------------

and in my postgresql.conf I have set

        tcpip_socket = true

So what is wrong here?

Oh yes, I have had allready problems while upgrading because on my
Devel-Station the location is /PostgreSQL and not /var/lib/postgres
and on my FileServer it is on /home/postgres.

I am using Debian since Slink, but now since Sarge, only 70% of my
network is working correctly...  realy strange with Sarge!

And last not least:

+---[ command 'pstree -panA' ]--------------------------------------
| 
| init,1       
|   |-(keventd,2)
|   |-(ksoftirqd_CPU0,3)
|   |-(kswapd,4)
|   |-(bdflush,5)
|   |-(kupdated,6)
|   |-(kjournald,96)
|   |-(scsi_eh_0,224)
|   |-(scsi_eh_1,225)
|   |-(khubd,232)
|   |-(kcopyd,262)
|   |-(kjournald,291)
|   |-(kjournald,292)
|   |-(kjournald,293)
|   |-(kjournald,294)
|   |-(kjournald,295)
|   |-portmap,368
|   |-klogd,540
|   |-courierlogger,548 -pid=/var/run/courier/authdaemon/pid -start/
| usr/lib/courier/authlib/a
|   |   `-authdaemond.pla,549
|   |       |-authdaemond.pla,554
|   |       |-authdaemond.pla,556
|   |       |-authdaemond.pla,557
|   |       |-authdaemond.pla,558
|   |       `-authdaemond.pla,559
|   |-courierd,561
|   |   `-courierd,16892
|   |       |-courieruucp,16893
|   |       |-courierlocal,16894
|   |       |-courierfax,16895
|   |       |-courieresmtp,16896
|   |       `-courierdsn,16897
|   |-courierfilter,566 start
|   |-courierlogger,568 courierfilter
|   |-couriertcpd,579 -stderrlogger=/usr/sbin/courierlogger -user=da
| emon -group=daemon-access
|   |-courierlogger,583 courieresmtpd
|   |-couriertcpd,588 -stderrlogger=/usr/sbin/courierlogger -stderrl
| oggername=esmtpd-ssl-maxp
|   |-courierlogger,591 esmtpd-ssl
|   |-hddtemp,616 -d -l 127.0.0.1 -p 7634 -s | -S 120 /dev/hda /dev/
| hdc /dev/hde /dev/hdg /dev/hdi /dev/hdk /dev/hdm /dev/hdo 
|   |-inetd,621
|   |-uptimed,683
|   |-atd,690
|   |-cron,693
|   |-apache,700
|   |   |-apache,15600
|   |   |-apache,15601
|   |   |-apache,15602
|   |   |-apache,15603
|   |   |-apache,15604
|   |   |-apache,15605
|   |   |-apache,15664
|   |   |-apache,15665
|   |   |-apache,15666
|   |   `-apache,15667
|   |-getty,734 -f /etc/issue.linuxlogo 38400 tty4
|   |-getty,735 -f /etc/issue.linuxlogo 38400 tty5
|   |-getty,736 -f /etc/issue.linuxlogo 38400 tty6
|   |-(kjournald,2846)
|   |-sshd,3067
|   |   `-sshd,1442
|   |       |-sshd,1444
|   |       `-bash,1446
|   |           `-pstree,17730 -panA
|   |-spamd,4991
|   |   |-spamd,4480
|   |   |-spamd,11957
|   |   |-spamd,17034
|   |   |-spamd,23688
|   |   `-spamd,30290
|   |-(nfsd,9844)
|   |-(nfsd,9845)
|   |-(nfsd,9846)
|   |-(lockd,9847)
|   |   `-(rpciod,9848)
|   |-(nfsd,9849)
|   |-(nfsd,9850)
|   |-(nfsd,9851)
|   |-(nfsd,9852)
|   |-(nfsd,9853)
|   |-rpc.mountd,9856
|   |-rpc.statd,9866
|   |-getty,11132 -f /etc/issue.linuxlogo 38400 tty3
|   |-getty,15469 -f /etc/issue.linuxlogo 38400 tty2
|   |-getty,15470 -f /etc/issue.linuxlogo 38400 tty1
|   |-postmaster,17370 -i -D /home/postgres/data
|   |   `-postmaster,17375                           
|   |       `-postmaster,17377                        
|   |-pg_autovacuum,17381 -D -p 5432 -L /var/log/postgresql/autovacu
| um_log
|   `-syslogd,29394
+-------------------------------------------------------------------

So all is theoreticaly working fine...

Oh before I forget:

I am using pam-pgsql and libnss-pgsql1, which mean, that I can not
more login on ANY Workstations, Servers or Routers, if my PostgreSQL
7.4.7 under Sarge doest not more allow TCP/IP connections.

It was a realy great dist-upgrade!

Greetings
    Michelle