On Thu, Feb 16, 2012 at 8:14 PM, Adrian Klaver wrote:
> On Wednesday, February 15, 2012 10:21:02 pm Venkat Balaji wrote:
> > Andrian,
> >
> > Thanks a lot !
> >
> > So in this case you are not waiting for confirmation of the commit being
> >
> > > flushed
> > > to disk on the standby. It that cas
On Wednesday, February 15, 2012 10:21:02 pm Venkat Balaji wrote:
> Andrian,
>
> Thanks a lot !
>
> So in this case you are not waiting for confirmation of the commit being
>
> > flushed
> > to disk on the standby. It that case you are bypassing the primary
> > reason for
> > sync replication. T
Andrian,
Thanks a lot !
So in this case you are not waiting for confirmation of the commit being
> flushed
> to disk on the standby. It that case you are bypassing the primary reason
> for
> sync replication. The plus is transactions on the master will complete
> faster
> and do so in the absenc
On Wednesday, February 15, 2012 2:15:34 am Venkat Balaji wrote:
> In-short, I would like to understand if i am achieving the same
> asynchronous streaming replication by putting synchronous_commit='local' -
>
> I understand that streaming replication is record based log-shipping.
>
> Below is wha
In-short, I would like to understand if i am achieving the same
asynchronous streaming replication by putting synchronous_commit='local' -
I understand that streaming replication is record based log-shipping.
Below is what shows up on our primary test server where we are testing
synchronous repli
On Wed, Feb 15, 2012 at 11:01 AM, Venkat Balaji wrote:
>
> On Tue, Feb 14, 2012 at 8:09 PM, Adrian Klaver wrote:
>
>> On Tuesday, February 14, 2012 4:21:22 am Venkat Balaji wrote:
>> > Hello,
>> >
>> > Disaster Recovery testing for Synchronous replication setup -
>> >
>> > When the standby site is
On Tue, Feb 14, 2012 at 8:09 PM, Adrian Klaver wrote:
> On Tuesday, February 14, 2012 4:21:22 am Venkat Balaji wrote:
> > Hello,
> >
> > Disaster Recovery testing for Synchronous replication setup -
> >
> > When the standby site is down, transactions at the production site
> started
> > hanging (t
On Tuesday, February 14, 2012 4:21:22 am Venkat Balaji wrote:
> Hello,
>
> Disaster Recovery testing for Synchronous replication setup -
>
> When the standby site is down, transactions at the production site started
> hanging (this is after the successful setup of synchronous replication).
>
> W
Hello,
Disaster Recovery testing for Synchronous replication setup -
When the standby site is down, transactions at the production site started
hanging (this is after the successful setup of synchronous replication).
We changed synchronous_commit to 'local' to over-come this situation.
- No tr
This issue stays resolved !!!
The statements are no more hanging on production now :)
The suspected problem was -
Our brand new production server did not have the port 5432 open.
I had opened the port using "iptables" command and everything started
working.
synchronous replication is fast and
On Thursday, February 02, 2012 10:21:28 pm Venkat Balaji wrote:
>
> Connection is working fine between primary and standby, ping is working
> fine and wal archive file transfer is working without any issues.
>
> I tried CREATE TABLE and CREATE DATABASE, both were hanging.
>
> Apart from regular
On Thu, Feb 2, 2012 at 8:37 PM, Adrian Klaver wrote:
> On Wednesday, February 01, 2012 10:51:44 pm Venkat Balaji wrote:
> > Hello,
> >
> > I was testing the Postgres-9.1.1 synchronous streaming replication on our
> > UAT system.
> >
> > Without synchronous replication, everything was working fine.
On Wednesday, February 01, 2012 10:51:44 pm Venkat Balaji wrote:
> Hello,
>
> I was testing the Postgres-9.1.1 synchronous streaming replication on our
> UAT system.
>
> Without synchronous replication, everything was working fine.
>
> But, when i enabled synchronous_replication_names='*', the "
synchronous_commit is "on"
Thanks
VB
On Thu, Feb 2, 2012 at 12:31 PM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> What is the value of synchronous_commit ?
>
> ---
> Regards,
> Raghavendra
> EnterpriseDB Corporation
> Blog: http://raghavt.blogspot.com/
>
>
>
> On Thu, Feb 2, 2012 at
What is the value of synchronous_commit ?
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Thu, Feb 2, 2012 at 12:21 PM, Venkat Balaji wrote:
> Hello,
>
> I was testing the Postgres-9.1.1 synchronous streaming replication on our
> UAT system.
>
> Without
Hello,
I was testing the Postgres-9.1.1 synchronous streaming replication on our
UAT system.
Without synchronous replication, everything was working fine.
But, when i enabled synchronous_replication_names='*', the "create table"
started hanging for long time.
When i pressed "Ctrl+C" i got the f
16 matches
Mail list logo
