Search Postgresql Archives

Re: Replication

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

 




On 02/11/10 01:56, Scott Marlowe wrote:
On Mon, Nov 1, 2010 at 4:39 PM, Jonathan Tripathy<jonnyt@xxxxxxxxxxx>  wrote:
On 01/11/10 21:10, Vick Khera wrote:
On Mon, Nov 1, 2010 at 3:53 PM, Jonathan Tripathy<jonnyt@xxxxxxxxxxx>
  wrote:
The standby must support INSERTS and UPDATES as well (once the master has
failed)

Are there any solutions like this? Looking on the Postgresql site, all
the
standby solutions seem to be read only..
If they are RO it is only while they are replicas, not masters.  Once
the server is upgraded to the master role, it becomes RW.

So in the "Hot Standby" setup as described in
http://www.postgresql.org/docs/current/static/hot-standby.html , how would I
automatically make the slave a master?
I think you're looking for this:
http://www.postgresql.org/docs/current/static/warm-standby-failover.html

What is the difference between the "Hot-Standby" and "Warm-Standby"? Is the only different that the "Hot-Standby" standby servers are read-only, whereas the "Warm-Standby" standbys can't be queried at all?

Thanks

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[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