Re: Replication using WAL files

On 12/7/07, Josh Harrison <joshques@gmail.com> wrote:
> I have 2 servers on which I need to have data replicated. The master server
> should serve for read/write queries and the 2nd server is used mainly for
> research queries(read-only queries) and so it doesn't have to be up-to-date.
...
> Is it possible to implement this thro' WAL shipping?

No. At the moment [1] the WAL shipping system does not permit you to
query the slave. There are a few options:

  http://pgfoundry.org/search/?type_of_search=soft&words=replication&Search=Search

As well as this:

  http://bucardo.org/

[1] But someone is working on this for 8.4. Don't hold your breath, though.

Alexander.