This is the mail archive of the
cygwin@cygwin.com
mailing list for the Cygwin project.
PostgreSQL 7.3 conenct failure - No pg_hba.conf entry for host
- From: letters at hotpop dot com
- To: cygwin at cygwin dot com
- Cc: jari dot aalto at poboxes dot com
- Date: Wed, 14 May 2003 00:02:41 +0300
- Subject: PostgreSQL 7.3 conenct failure - No pg_hba.conf entry for host
- Keywords: debug,exit,host,trust,log,database,postgres,hba
[Please keep CC, if possible]
I upgraded Win2000 server to postgres 7.3 with ipc-daemon and
all. The upgrade succeeded ok and I can connect locally to
the databases. The problem is remote connection, which I
do not see what might be the trouble. Do you see anything to
correct in pg_hba.conf file?
I'm lost, why the connection fails.
Jari
[the CLIENT]
C:\>ipconfig
Windows NT IP Configuration
Ethernet adapter El90x1:
IP Address. . . . . . . . . : 195.148.57.116
bash$ psql -h SERVER template1 postgres
psql: FATAL: No pg_hba.conf entry for host 195.148.57.116, user postgres, database template1
---------------------------------------
[The SERVER]
bash$ cat /usr/share/postgresql/pg_hba.conf
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
host all all 195.148.57.116 255.255.255.255 trust
host all all 195.148.0.1 255.255.0.0 trust
host all all 192.0.0.1 255.0.0.0 trust
bash$ ipc-daemon --help
/usr/local/bin/ipc-daemon : Cygwin IPC Package Version 1.13 (c) 1998 PCH/LLA, Changes (c) 2001 CSW
bash$ postmaster -i -D /usr/share/postgresql/data -d 5
LOG: database system was shut down at 2003-05-13 19:11:18 EETDST
LOG: checkpoint record is at 0/84D7A8
LOG: redo record is at 0/84D7A8; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 498; next oid: 16977
LOG: database system is ready
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
DEBUG: reaping dead processes
DEBUG: BackendStartup: forked pid=1064 socket=11
FATAL: No pg_hba.conf entry for host 195.148.57.116, user postgres, database template1
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
DEBUG: reaping dead processes
DEBUG: child process (pid 1064) exited with exit code 0
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
DEBUG: reaping dead processes
DEBUG: child process (pid 2628) exited with exit code 0
--
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Problem reports: http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ: http://cygwin.com/faq/