Postgres Pro
Downloads
Home   >   mailing lists

shutdown Postgres (standby) host causing timeout on other servers in replication - Mailing list pgsql-general

From Joanna Xu
Subject shutdown Postgres (standby) host causing timeout on other servers in replication
Date
Msg-id AM9PR06MB8313D3D3BF650CD8CC468FA984389@AM9PR06MB8313.eurprd06.prod.outlook.com
Whole thread Raw
Responses Re: shutdown Postgres (standby) host causing timeout on other servers in replication  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: shutdown Postgres (standby) host causing timeout on other servers in replication  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view

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

pgsql-general by date:

Previous
From: Siddharth Jain
Date:
Subject: Re: Some questions about Postgres
Next
From: Bryn Llewellyn
Date:
Subject: 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"