On 12/7/07, Josh Harrison < joshques@xxxxxxxxx> 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.
Thanks for the info. Just to clarify, So at the moment for WAL shipping to work the 2nd server should only be a stand-by server and not a slave(cannot be queried) ?
In your experience, which other replication system (slony,pgpool etc) is better suited for my requirement?
Thanks again
josh
