On 12/7/07, Josh Harrison <[EMAIL PROTECTED]> 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
