On Tue, 2007-04-24 at 11:31 +0200, Alexander Staubo wrote: > On 4/24/07, Mageshwaran <j_mageshwaran@xxxxxxxxxxxx> wrote: > > I want to do replication using WAL , please tell the methods by which > > log shipping is done ie moving the wal files to slaves and executing it. > > Not possible at the moment: the log shipping facility that was > introduced in 8.2 only lets you set up a so-called warm standby, which > cannot be queried; it's not live replication. > > The warm standby system is a fairly crude hack that relies on WAL > files being copied from the main server to the standby and then > starting the standby in recovery mode when you want to bring it up. At > this point the standby is your main database, and it can no longer WAL > files. Documented here: > > http://www.postgresql.org/docs/8.2/static/warm-standby.html The use-case for Warm Standby is for people that want a simple, efficient mechanism for providing High Availability replication. If there are any feature requests, please let me know. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com
