From: | teknokrat <teknokrat(at)yahoo(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Concurrent Connections - User only allowed one |
Date: | 2003-10-03 11:33:07 |
Message-ID: | bljmpf$2enm$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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.
>
> GTG
>
>
>>>>Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> 03/10/2003 11:19:55 >>>
>
>
> On 03/10/2003 08:43 Gordon Ross wrote:
>
>>(Running PG 7.3.4 on Sparc Solaris 9)
>>
>>I have a Java application (which connects to Postgres using JDBC)
>
> which
>
>>I run from the Solaris box, but which I develop from my desktop PC.
>
> When
>
>>my application connects to Postgres, it can only obtain one
>
> connection.
>
>>i.e. if the server app is running, then my PC cannot connect, but if
>
> my
>
>>PC version is running, then the server cannot connect.
>>
>>If the server app is running, then I cannot connect with other tools
>>from my PC (e.g. EMS Postgres manager), but I can always connect
>
> using
>
>>psql from the Solaris command line.
>>
>>Is this a bug, feature or just good old human error (on my part) ?
>
>
> It soulds like you need to increase max_connections in
> postgresql.conf.
>
> HTH
>
You need to add 192.168.24.108 to your trusted hosts in pg_hba.conf,
helps to RTFM too
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2003-10-03 12:11:09 | Re: Stored procedures |
Previous Message | Gordon Ross | 2003-10-03 10:35:29 | Re: Concurrent Connections - User only allowed one |