One of my clients is upgrading some servers. The procedure we have took some time to get to current state, and we found some potential problems, so decided to write more about it.

I had to deal with this question, or some version of it, quite a few times. So, decided to write a summary on what one could (or should) do, after data is in database, and application is running. Namely - ...

On 13th of December, Heikki Linnakangas committed patch: Allow a streaming replication standby to follow a timeline switch. Before this patch, streaming replication would refuse to start replicating if the timeline in the primary doesn't exactly match the standby. The situation where it doesn't ...

On 19th of July, Simon Riggs committed patch: Cascading replication feature for streaming log-based replication. Standby servers can now have WALSender processes, which can work with either WALReceiver or archive_commands to pass data. Fully updated docs, including new conceptual terms of sending server, upstream ...

On 6th of March, Simon Riggs committed patch: Efficient transaction-controlled synchronous replication. If a standby is broadcasting reply messages and we have named one or more standbys in synchronous_standby_names then allow users who set synchronous_replication to wait for commit, which then provides strict data integrity ...

On 16th of February, , Robert Haas committed patch: pg_ctl promote   Fujii Masao, reviewed by Robert Haas, Stephen Frost, and Magnus Hagander.

As of yesterday OmniPITR got following changes/fixes: Fixed bug which caused immediate finish request be treated the same as smart finish request. Fixed problem with using omnipitr-backup-slave on PostgreSQL 9.0 slave, which is using streaming replication. Added option to omnipitr-restore, so that you ...

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 ...

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.

The BIG feature. The feature that made PostgreSQL leap from 8.4 to 9.0. Patch was written by Fujii Masao, and committed by Heikki Linnakangas on 15th of January 2010: Log Message: ----------- Introduce Streaming Replication.   This includes two new kinds of postmaster processes, walsenders ...