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. Alexander. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
