| From: | Amine Tengilimoglu <aminetengilimoglu(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | Postgresql Conections Get Stuck on BIND and Server Don't Reboot |
| Date: | 2018-06-21 07:26:52 |
| Message-ID: | CADTdw-yjBhn9QvADn6CTqZAF8eXoroxYn+HLARHi_wsa2Cxu2Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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....
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mario De Frutos Dieguez | 2018-06-21 14:07:57 | Problem with a "complex" upsert |
| Previous Message | David G. Johnston | 2018-06-20 22:44:48 | Re: explaining the pg_total_relation_size/pg_relation_size results |