Postgresql Conections Get Stuck on BIND and Server Don't Reboot - Mailing list pgsql-admin

From Amine Tengilimoglu
Subject Postgresql Conections Get Stuck on BIND and Server Don't Reboot
Date
Msg-id CADTdw-yjBhn9QvADn6CTqZAF8eXoroxYn+HLARHi_wsa2Cxu2Q@mail.gmail.com
Whole thread Raw
List pgsql-admin

 Hello everyone;

  We are facing an error 3 times as the following. Our Postgresql 9.6.5 database servers has got "stuck".  And we couldn’t  fix this. There is nothing in the logs to indicate a problem. We have tried restarting the server. Is there anyone who faced this problem before?


 

Postgres version = 9.6.5

Shared buffers = 12GB

Max_connection = 800

Server RAM = 94GB

Linux CentOS7 =  Linux 3.10.0-693.el7.x86_64  (16 CPU)

We have a standby server but asynchronous status...

 

Before BIND status,  our process like this;






After a while;





At the time of  problem, iostat:





Does anyone have any ideas on this?? 


thanks in advance....

  
Attachment

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: explaining the pg_total_relation_size/pg_relation_size results
Next
From: Mario De Frutos Dieguez
Date:
Subject: Problem with a "complex" upsert