From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
---|---|
To: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
Cc: | "Hannu Krosing" <hannu(at)skype(dot)net>, <apoc9009(at)yahoo(dot)de>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [FEATURE REQUEST] Streaming Onlinebackup(Maybe OFFTOPIC) |
Date: | 2007-09-06 20:50:22 |
Message-ID: | 87hcm7zfg1.fsf@oxford.xeocode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
"Simon Riggs" <simon(at)2ndquadrant(dot)com> writes:
> High Availability
> -----------------
> - Allow a warm standby system to also allow read-only statements
> - Allow WAL traffic to be streamed to another server for stand-by
> replication (synchronous/asynchronous options)
Asynchronous streaming of WAL would be a very good feature.
Synchronous streaming where a commit doesn't return until the backup server
(or a quorum of backup servers if you have more than one) acknowledges receipt
of the logs past the commit record would be an *extremely* good feature.
Those could be broken out into two separate points. Streaming WAL is one
thing, feedback and pitr-synchronous commits would be a second point.
Knowing what WAL record the backup server had received so far and what WAL
record it had processed so far would be useful for plenty of other purposes as
well.
> - Improve scalability of recovery for large I/O bound databases
That seems too vague for the TODO. Did you have specific items in mind?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2007-09-06 21:01:29 | Re: [FEATURE REQUEST] Streaming Onlinebackup(Maybe OFFTOPIC) |
Previous Message | Hannu Krosing | 2007-09-06 20:30:10 | Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC) |