Re: Concurrent Connections - User only allowed one

and you HUPPED postmaster after changing this?

--dc--
On Fri, 2003-10-03 at 10:32, Gordon Ross wrote:
> OK, error from server.log:
>
> FATAL:  No pg_hba.conf entry for host 192.168.24.108, user postgres, database switchboards
>
> entries in 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         192.168.24.108    255.255.255.255   trust
>
> 192.168.24.108 is my PCs IP address.
>
> Thanks,
>
> GTG
>
> >>> Tom Lane <tgl@sss.pgh.pa.us> 03/10/2003 15:24:47 >>>
> Paul Thomas <paul@tmsl.demon.co.uk> writes:
> > On 03/10/2003 11:35 Gordon Ross wrote:
> >> OK. I increased it from the default of 32 to 128 and did a pg_ctl
> >> reload. Still get the same problem. With server running (but doing
> >> nothing), cannot connect from PC, I get the error message: "No
> >> pg_hba.conf entry for host 192.168.24.108" - yet shutting down the
> >> server process allows the PC to connect.
>
> > Wierd. It sounds like your server program is grabbing every possible
> > tcp/ip connection to the db.
>
> I don't think that's the issue at all --- if it were an
> out-of-connections situation, that error message would not be what comes
> up.  But I cannot think how the presence of one connection would affect
> the ability of another to match a pg_hba.conf entry.  What do you have
> in pg_hba.conf, anyway??  Does the complaint message actually match your
> PC's address?  (And let's see the entire error message, please, not an
> edited subset.  Looking in the postmaster log to see if more is reported
> there would be helpful too.)
>
>             regards, tom lane
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>
--
Dave Cramer <Dave@micro-automation.net>