Skip site navigation (1) Skip section navigation (2)

Re: pg_start_backup and pg_stop_backup Re: Re:[COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend uponcorrect

From: Aidan Van Dyk <aidan(at)highrise(dot)ca>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>,Simon Riggs <simon(at)2ndQuadrant(dot)com>,Josh Berkus <josh(at)agliodbs(dot)com>,Alvaro Herrera <alvherre(at)commandprompt(dot)com>,Fujii Masao <masao(dot)fujii(at)gmail(dot)com>,Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org,Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: pg_start_backup and pg_stop_backup Re: Re:[COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend uponcorrect
Date: 2010-04-28 20:38:49
Message-ID: 20100428203849.GM17479@oak.highrise.ca (view raw or flat)
Thread:
Lists: pgsql-hackers
* Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> [100428 15:51]:
  
> > I don't personally care about streaming replication replaying WAL
> > as it comes, or running queries in recovery...
>  
> I'm with you that far, but I wouldn't want the sender to wait for
> remote persistence.

I remember a presentation at pgcon a while ago, it was probaly Fujii
(from NTT?) about their log streaming, and at that time, they talked
about different "sync" options...  So I'ld love to be able to have
comits be:
   async (like current option)
   local wal sync (like current)
   local wal sync + walsender sent
   local wal sync + walsender confirmed

And ideally, the "walsender sent/confirmed" would even allow making sure
it was sent/confirmed to $X connections...  I want to be able to
guarantee it's on 2 machines, not that if my slave was connected it
would be on there, but something happened and my "slave"
has disconnected, so it's only got local WAL... 

And then on whatever "tool" is receiving the log streaming, it can be
set to confirm when either:
   received buffer
   write buffer to file
   write buffer to file + sync
   write buffer to file + sync + replay

That should give you all the sync levels they talked about in their
presentation...

-- 
Aidan Van Dyk                                             Create like a god,
aidan(at)highrise(dot)ca                                       command like a king,
http://www.highrise.ca/                                   work like a slave.

In response to

Responses

pgsql-hackers by date

Next:From: Jaime CasanovaDate: 2010-04-28 22:19:48
Subject: Re: Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints
Previous:From: Dimitri FontaineDate: 2010-04-28 20:17:42
Subject: Re: pg_start_backup and pg_stop_backup Re: Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group