Search Postgresql Archives

Re: Read-only availability of a standby server?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 note
Everything 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@xxxxxxxxxx> 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@xxxxxxxxxxxxxx so that your
> message can get through to the mailing list cleanly



Connect and share in new ways with Windows Live. Connect now!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux