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.