Waiting for 9.1 – pg_basebackup

On 23rd of January, Magnus Hagander committed patch which adds:

Add pg_basebackup tool for streaming base backups
 
This tool makes it possible to do the pg_start_backup/
copy files/pg_stop_backup step in a single command.
 
There are still some steps to be done before this is a
complete backup solution, such as the ability to stream
the required WAL logs, but it's still usable, and
could do with some buildfarm coverage.
 
In passing, make the checkpoint request optionally
fast instead of hardcoding it.
 
Magnus Hagander, reviewed by Fujii Masao and Dimitri Fontaine

Continue reading Waiting for 9.1 – pg_basebackup

Waiting for 9.1 – pg_stat_replication

On 7th of January (I know, it was quite some time ago, I apologize for delay) Itagaki Takahiro committed patch:

New system view pg_stat_replication displays activity of wal sender processes.
 
Itagaki Takahiro and Simon Riggs.

Continue reading Waiting for 9.1 – pg_stat_replication