On 19th of December Simon Riggs committed a patch that will quite likely be the single most-talked-about change in PostgreSQL 8.5: Log Message: ----------- Allow read only connections during recovery, known as Hot Standby.   Enabled by recovery_connections = on (default) and forcing archive ...

Like practically any application, applications that I deal with evolve. They change their requirements when it comes to database storage - new tables, new columns, modified columns. Or perhaps - new base data - like new values in virtually static ...