Re: Error: server closed the connection unexpectedly

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Error: server closed the connection unexpectedly
Дата
Msg-id 122c4f4b-17c5-d0e5-f8a7-c541cfb910d6@aklaver.com
обсуждение исходный текст
Ответ на Re: Error: server closed the connection unexpectedly  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: Error: server closed the connection unexpectedly  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
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@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.

> 
> -- 
> Angular momentum makes the world go 'round.


-- 
Adrian Klaver
adrian.klaver@aklaver.com



В списке pgsql-general по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Error: server closed the connection unexpectedly
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Error: server closed the connection unexpectedly