Could you explain what hot-standby characteristic is most important?If you desire to replicate <segments of> your Write-ahead log take a look at Point In Time Recovery
http://www.postgresql.org/docs/8.1/static/backup-online.html
If you desire to use separate physical machines with ability to replicate schema changes take a look at SLONY
http://slony.info/
Anyone ?Martin--______________________________________________Disclaimer and confidentiality noteEverything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.> > -----BEGIN PGP SIGNED MESSAGE-----> Hash: SHA1> > On Wed, 21 Nov 2007 12:20:51 -0800> "Garber, Mikhail" <mgarber(at)amazon(dot)com> wrote:> > > In the high-availabilty situation with a warm standby, is it possible> > (or planned) to be able to make standby readable? This is a new> > feature in Oracle 11 and it is very important for a project I am> > working on.> > > > There was a Google Summer of Code project IIRC for that... So yes, it> has been worked on a bit but I am unaware of the status.> > Joshua D. Drake> > > ---------------------------(end of> > broadcast)--------------------------- TIP 6: explain analyze is your> > friend> > > > > - -- > > === The PostgreSQL Company: Command Prompt, Inc. ===> Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240> PostgreSQL solutions since 1997 http://www.commandprompt.com/> UNIQUE NOT NULL> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate> PostgreSQL Replication: http://www.commandprompt.com/products/> > -----BEGIN PGP SIGNATURE-----> Version: GnuPG v1.4.6 (GNU/Linux)> > iD8DBQFHRJStATb/zqfZUUQRAmxtAJ9opNJn8N7f2Fv403EqAHh419vciwCgiW4o> zvQVFrrmnYVXuhd79PpgicY=> =tyRU> -----END PGP SIGNATURE-----> > ---------------------------(end of broadcast)---------------------------> TIP 1: if posting/reading through Usenet, please send an appropriate> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your> message can get through to the mailing list cleanly
_________________________________________________________________
Connect and share in new ways with Windows Live.
http://www.windowslive.com/connect.html?ocid=TXT_TAGLM_Wave2_newways_112007