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@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.
