Postgres Pro
Downloads
Home   >   mailing lists

Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help - Mailing list pgsql-admin

From Sofer, Yuval
Subject Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help
Date
Msg-id 2C0926ABD16BB641A8E2F11A549200423DDBC79BF2@PHXCCRPRD01.adprod.bmc.com
Whole thread Raw
Responses Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help
List pgsql-admin
Tree view

Hi,

 

I am using Postgres DB with stand by database, configured with streaming in synchronized mode (each commit on primary DB waits for commit on secondary DB).

 

Sometimes we suffer from network issues and as consequences, secondary machine is not available.

 

In these situations, our application is stuck and do not respond anymore, since no confirmation comes from the secondary Postgres (obviously… it is down or unavailable….).

 

Is there any parameter that I can use, to enable recovering from hanging on until someone of us re-establish connection to secondary DB?

Maybe some configuration parameter that sets the time interval for being stuck because of unavailable secondary Postgres?

 

Please help,

 

Thanks,

 

 

Yuval Sofer

BMC Software

CTM&D Business Unit

DBA Team

972-52-4286-282

yuval_sofer@bmc.com

 

 

 

 

 

 

 

pgsql-admin by date:

Previous
From: Brett Stauner
Date:
Subject: Re: Upgrade from 8.4
Next
From: Scott Ribe
Date:
Subject: Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help