Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sources.redhat.com/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
X-Authentication-Warning:	newton.tpu.fi: jaalto set sender to jari DOT aalto AT tpu DOT fi using -f
From:	letters AT hotpop DOT com
To:	cygwin AT cygwin DOT com
CC:	jari DOT aalto AT poboxes DOT com
Subject:	Postgres 7.3 - pg_hba.conf entry for host nof found (it's there!)
Keywords:	debug,exit,host,database,trust,server,log,processes
Date:	Tue, 13 May 2003 19:27:24 +0300
Message-ID:	<jn7k8udd77.fsf@blue.sea.net>
MIME-Version:	1.0

    [Please keep CC if you can]

    I upgraded postgresql 7.3 under Win2000 server + all of Cygwin +
    ipc-daemon. I shut down all processes, replaced ipc-daemon and
    recreated all databases as usual. All went ok.

    I can connect locally to the database from the SERVER machine, but
    outside connections deos not work. Does anyone have more ideas to
    check? I restarted the server every time I changed the pg_hba.conf
    file, but it just down't take fire.

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

- Raw text -