| From: | Joanna Xu <Joanna(dot)Xu(at)amdocs(dot)com> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Cc: | "Sandeep Yadav (93247)" <Sandeep(dot)Yadav2(at)amdocs(dot)com>, Sylwester Czerniewicz <Sylwester(dot)Czerniewicz(at)amdocs(dot)com> |
| Subject: | shutdown Postgres (standby) host causing timeout on other servers in replication |
| Date: | 2022-11-03 20:55:36 |
| Message-ID: | AM9PR06MB8313D3D3BF650CD8CC468FA984389@AM9PR06MB8313.eurprd06.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi All,
We have PostgreSQL master-slave replication configuration with 4 servers.
After shutting down one standby server, we found below errors on all other 3 servers and the applications couldn't access the database due to the timeout.
DAO-00002 datasource connection failure:Time out waiting for a DefaultDataSource
ERROR SQLException code: 0 SQLState: null
What could be the cause of the errors? Would anyting be helpful to prevent it from happening?
Thank you for the help!
Cheers,
Joanna Xu
DB Specialist | Amdocs OPEN NETWORK
+1 613 595 5234 (office)
+1 613 899 6178 (mobile)
+1 877 943 3772 (24hr support line)
This email and the information contained herein is proprietary and confidential and subject to the Amdocs Email Terms of Service, which you may review at https://www.amdocs.com/about/email-terms-of-service <https://www.amdocs.com/about/email-terms-of-service>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bryn Llewellyn | 2022-11-03 21:49:04 | Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" |
| Previous Message | Siddharth Jain | 2022-11-03 18:17:24 | Re: Some questions about Postgres |