Re: Unable To Establish Connections - Mailing list pgsql-admin

From Tim
Subject Re: Unable To Establish Connections
Date
Msg-id BANLkTino-oNwQmM_gVkQs8ozSSiMjR+AMQ@mail.gmail.com
Whole thread Raw
In response to Re: Unable To Establish Connections  (Sam Stearns <samtstearns@gmail.com>)
Responses Re: Unable To Establish Connections
List pgsql-admin
First google hit said this:

"It seems (not sure) to occur when user retypes password fast.
Maybe in this case ODBC driver gets old connection somehow from driver
manager."

also
"It looks to me like the ODBC driver is failing to follow the protocol.
It shouldn't respond with an 'X' if it doesn't have a password, just
disconnect."

I would start logging traffic so you have more to go on next time it happens.

On Tue, May 17, 2011 at 6:52 PM, Sam Stearns <samtstearns@gmail.com> wrote:
Anyone have any ideas on this?  We're an ISP.  I was thinking of the
possibility of a hack attempt.

On Tue, May 17, 2011 at 6:52 PM, Sam Stearns <samtstearns@gmail.com> wrote:
> Howdy,
>
> Environment:
>
> Postgres 8.2.3
> Solaris 10
>
> We were unable to make a remote postgres connection for ~2 hours this
> afternoon.  Receiving the following message in the postgres log every
> 30 seconds:
>
> LOG:  expected password response, got message type 88
>
> Connection limit is 300.  17 active connections at the time.  Bounced
> postgres successfully but the above error message was still being
> logged.  About 20 minutes later the error message stopped and
> connections started to re-establish.
>
> Any ideas?
>
> Thank you,
>
> Sam
>

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: Sam Stearns
Date:
Subject: Re: Unable To Establish Connections
Next
From: Sam Stearns
Date:
Subject: Re: Unable To Establish Connections