On Dec 7, 2007 9:52 AM, Josh Harrison <joshques@xxxxxxxxx> wrote: > I tried the 'Continuous Archiving and PITR' in my test database and it works > fine. But this set-up is only for a warm standby server...right?! Is it > possible to make both the servers work asynchronously, while the primary > server takes up all write queries and the read queries can be sent to both > primary and 2nd server .And can the 2nd server be updated using the WAL > files (WAL shipping) of the primary server asynchronously (while both the > servers are up)? PITR currently is for HA only, not replication. Check out slony. merlin ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend