Re: Error: server closed the connection unexpectedly - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Error: server closed the connection unexpectedly
Date
Msg-id ed3e5239-2312-80c3-b5cc-1e596a1ae9e6@aklaver.com
Whole thread Raw
In response to Re: Error: server closed the connection unexpectedly  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
On 10/10/21 13:06, Ron wrote:
> On 10/10/21 3:00 PM, Tom Lane wrote:
>> Ron <ronljohnsonjr@gmail.com> writes:
>>> This is AWS RDS Postgresql.  The db server log is accessed via a web
>>> interface, and is /the/ postgresql log just like you see in vanilla 
>>> Postgresql.
>>> I've attached it.  My attempt to connect happened some time between 
>>> between
>>> 04:10:30 and 04:17:30.
>> Hm.  Not much there.  You might try turning on log_connections to be
>> sure,
> 
> I'll do that.
> 
>>   but what this looks like is that the connection request never
>> got to the server.  Maybe you've got some middleware involved, like
>> pgpool or some other connection pooler?
> 
> If so, it must be something hidden by AWS, because I never installed it.
> 
> The crazy thing is that coworkers with accounts on the same VM can 
> connect to the instance just fine.  (Yes, we use the exact same command 
> to connect, as a test.)

Are the AWS security groups set up correctly.

See here:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Troubleshooting.html#CHAP_Troubleshooting.Connecting

> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Error: server closed the connection unexpectedly
Next
From: Ron
Date:
Subject: Re: Error: server closed the connection unexpectedly