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 opt
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 keepaliv
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 in
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 betwe
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 fro
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 04:17:30
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. Yo
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 l
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 conne
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
27;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 mean
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 abnor
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 (i
16 matches
Mail list logo
