Hi All,
I am also facing a similar issue. In my case I am connecting to AWS Aurora
PostgreSQL.
When my psql session is idle for a while ( for 5 - 10 minutes ) , It gets
terminated and reconnect but query/transaction started by earlier session
remain in `idle in transaction` state and the only
On Mon, 2021-10-11 at 00:12 +0530, Anil wrote:
> Please find the server log, if you can find something (due to some reasons
> not being able to get OS system log, will be shared soon).
Nothing to see.
Perhaps an ill-configured network component closes idle connection?
In that case, try
Hi Adrian/Ron,
Please find the server log, if you can find something (due to some reasons
not being able to get OS system log, will be shared soon).
Thanks,
Anil
On Sun, Oct 10, 2021 at 10:56 PM Adrian Klaver
wrote:
> On 10/10/21 10:19, Anil wrote:
> Please reply to list also.
> Ccing list.
>
On 10/10/21 3:12 PM, Adrian Klaver wrote:
On 10/10/21 12:30, Ron wrote:
On 10/10/21 2:20 PM, Tom Lane wrote:
Ron writes:
I think Anil mentioned that there's *nothing* in the Postgresql server
log,
even (in my case) with log_min_messages cranked to debug5.
I'm skeptical that you're looking
On 10/10/21 13:06, Ron wrote:
On 10/10/21 3:00 PM, Tom Lane wrote:
Ron 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
On 10/10/21 12:30, Ron wrote:
On 10/10/21 2:20 PM, Tom Lane wrote:
Ron writes:
I think Anil mentioned that there's *nothing* in the Postgresql server log,
even (in my case) with log_min_messages cranked to debug5.
I'm skeptical that you're looking in the right place, then.
What do you get
On 10/10/21 3:00 PM, Tom Lane wrote:
Ron 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
Ron 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.
On 10/10/21 2:20 PM, Tom Lane wrote:
Ron writes:
I think Anil mentioned that there's *nothing* in the Postgresql server log,
even (in my case) with log_min_messages cranked to debug5.
I'm skeptical that you're looking in the right place, then.
What do you get from
show log_destination;
show
Ron writes:
> I think Anil mentioned that there's *nothing* in the Postgresql server log,
> even (in my case) with log_min_messages cranked to debug5.
I'm skeptical that you're looking in the right place, then.
What do you get from
show log_destination;
show log_directory;
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
On 10/10/21 10:19, Anil wrote:
Please reply to list also.
Ccing list.
For future reference do not include images for textual information. Copy
and paste the errors as text.
Response in line.
Thanks for the response.
1. I am facing with both (pgAdmin and in python). pgAdmin is throwing
this
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
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
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
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
16 matches
Mail list logo