Re: [GENERAL] Regarding WAL

On Tue, 2007-04-24 at 11:31 +0200, Alexander Staubo wrote:
> On 4/24/07, Mageshwaran <j_mageshwaran(at)sifycorp(dot)com> 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