http://simonwillison.net/2009-12-23T09:57:34+00:00Simon Willison2009-12-23T09:57:34+00:002009-12-23T09:57:34+00:00https://simonwillison.net/2009/Dec/23/postgresql/#atom-tag

<p><strong><a href="http://www.postgresql.org/about/news.1172">PostgreSQL 8.5alpha3 now available</a></strong></p> “Hot Standby, allowing read-only connections during recovery, provides a built-in master-slave replication solution.” Woohoo! <p>Tags: <a href="https://simonwillison.net/tags/hotstandby">hotstandby</a>, <a href="https://simonwillison.net/tags/masterslave">masterslave</a>, <a href="https://simonwillison.net/tags/postgresql">postgresql</a>, <a href="https://simonwillison.net/tags/replication">replication</a>, <a href="https://simonwillison.net/tags/scaling">scaling</a></p>

2009-10-28T09:02:37+00:002009-10-28T09:02:37+00:00https://simonwillison.net/2009/Oct/28/postgresql/#atom-tag

<p><strong><a href="http://it.toolbox.com/blogs/database-soup/alpha2-is-out-and-we-need-you-to-test-it-35032?rss=1">PostgreSQL 8.5 alpha 2 is out</a></strong></p> “P.S. If you’re wondering about Hot Standby and Synchronous Replication, they’re still under heavy development and still (at this point) expected to be in 8.5.”—Hot Standby is PostgreSQL-speak for MySQL-style master/slave replication for scaling your reads. <p>Tags: <a href="https://simonwillison.net/tags/databases">databases</a>, <a href="https://simonwillison.net/tags/hotstandby">hotstandby</a>, <a href="https://simonwillison.net/tags/postgresql">postgresql</a>, <a href="https://simonwillison.net/tags/replication">replication</a>, <a href="https://simonwillison.net/tags/scaling">scaling</a></p>

2009-03-08T09:28:20+00:002009-03-08T09:28:20+00:00https://simonwillison.net/2009/Mar/8/hotstandby/#atom-tag

<p><strong><a href="http://it.toolbox.com/blogs/database-soup/what-happened-to-hot-standby-30391?rss=1">What happened to Hot Standby?</a></strong></p> Hot Standby (the ability to have read-only replication slaves) has been dropped from PostgreSQL 8.4 and is now scheduled for 8.5. “Making hard decisions to postpone features which aren’t quite ready is how PostgreSQL makes sure that our DBMS is ”bulletproof“ and that we release close to on-time every year”. <p>Tags: <a href="https://simonwillison.net/tags/databases">databases</a>, <a href="https://simonwillison.net/tags/hotstandby">hotstandby</a>, <a href="https://simonwillison.net/tags/josh-berkus">josh-berkus</a>, <a href="https://simonwillison.net/tags/postgresql">postgresql</a>, <a href="https://simonwillison.net/tags/replication">replication</a>, <a href="https://simonwillison.net/tags/scaling">scaling</a></p>