Re: [FEATURE REQUEST] Streaming Onlinebackup(Maybe OFFTOPIC) - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: [FEATURE REQUEST] Streaming Onlinebackup(Maybe OFFTOPIC)
Date
Msg-id 87hcm7zfg1.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: [FEATURE REQUEST] Streaming Onlinebackup(Maybe OFFTOPIC)
List pgsql-hackers
"Simon Riggs" <simon@2ndquadrant.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


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)
Next
From: Simon Riggs
Date:
Subject: Re: [FEATURE REQUEST] Streaming Onlinebackup(Maybe OFFTOPIC)