Re: Error: server closed the connection unexpectedly

On 10/10/21 11:27 AM, Adrian Klaver wrote:
> On 10/9/21 23:18, Ron wrote:
>> On 10/9/21 3:26 PM, Adrian Klaver wrote:
>>> On 10/9/21 9:01 AM, Anil wrote:
>>>> Hi Team,
>>>>
>>>> I am using Postgres (AWS instance, version: PostgreSQL 12.7 on
>>>> x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat
>>>> 4.8.3-9), 64-bit) with python for programming and pgAdmin for querying.
>>>> However facing below error very often but did not see any aborted
>>>> information in log (in server activity, pdAdmin dashboard). Tried to
>>>> get support from open community but no luck so writing to you, could
>>>> you help me?
>>>
>>> What does the actual Postgres log show?
>> Adrian,
>>
>> I've been getting the same error for two months from psql 12.5 on an EC2
>> Linux host, trying to connect to an RDS Postgresql 12.7 instance, after
>> months of working properly.
>>
>> [a467197(at)uisawsprdlinrds ~]$ psql postgres
>> psql: error: server closed the connection unexpectedly
>>      This probably means the server terminated abnormally
>>      before or while processing the request.
>
> Unfortunately this message is from the wrong end of the transaction. You
> and the OP need to look on the server end for the cause. I would start
> with the Postgres server log and the OS system logs.

I think Anil mentioned that there's *nothing* in the Postgresql server log,
even (in my case) with log_min_messages cranked to debug5.
And, of course, we can't see the RDS system logs.

--
Angular momentum makes the world go 'round.