From: | Aidan Van Dyk <aidan(at)highrise(dot)ca> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, David Fetter <david(at)fetter(dot)org>, Heikki Linnakangas <heikki(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Configuring synchronous replication |
Date: | 2010-09-17 15:30:33 |
Message-ID: | 20100917153033.GF12415@oak.highrise.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
* Robert Haas <robertmhaas(at)gmail(dot)com> [100917 11:24]:
> On Fri, Sep 17, 2010 at 11:22 AM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> > On Fri, 2010-09-17 at 09:36 -0400, Aidan Van Dyk wrote:
> >
> >> I want to have them configured in a fsync WAL/style sync rep, I want to
> >> make sure that if the master comes up first after I get power back, it's
> >> not going to be claiming transactions are committed while the slave
> >> (which happens to have 4x the disks because it keeps PITR backups for a
> >> period too) it still chugging away on SCSI probes yet, not gotten to
> >> having PostgreSQL up yet...
> >
> > Nobody has mentioned the ability to persist the not-committed state
> > across a crash before, and I think it's an important discussion point.
>
> Eh? I think all Aidan is asking for is the ability to have a mode
> where sync rep is really always sync, or nothing commits. Rather than
> timing out and continuing merrily on its way...
Right, I'm not asking for a "new" mode. I'm just hope that there will
be a way to guarantee my "sync rep" is actually replicating. Having it
"not replicate" simply because no slave has (yet) connected means I have
to dance jigs around pg_hba.conf so that it won't allow non-replication
connections until I've manual verified that the replication slave
is connected...
a.
--
Aidan Van Dyk Create like a god,
aidan(at)highrise(dot)ca command like a king,
http://www.highrise.ca/ work like a slave.
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2010-09-17 15:49:44 | Re: Configuring synchronous replication |
Previous Message | Robert Haas | 2010-09-17 15:23:53 | Re: Configuring synchronous replication |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-09-17 15:39:04 | Re: Report: removing the inconsistencies in our CVS->git conversion |
Previous Message | Markus Wanner | 2010-09-17 15:29:46 | Re: bg worker: general purpose requirements |