From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help |
Date: | 2013-04-18 16:38:12 |
Message-ID: | 20130418163812.GA24028@tux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Sofer, Yuval <Yuval_Sofer(at)bmc(dot)com> wrote:
> 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?
Use asynchronous mode. There is no way for 'only a little bit
synchronized mode'. We are not in the mysql-world ...
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2013-04-18 18:18:03 | Re: ALTER USER abc PASSWORD - what's going on ??? |
Previous Message | Sofer, Yuval | 2013-04-18 15:41:22 | Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help |