Re: Replication

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Jonathan Tripathy <jonnyt(at)abpni(dot)co(dot)uk>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Replication
Date: 2010-11-02 17:32:05
Message-ID: 1288719125.1867.19438.camel@ebony
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2010-11-02 at 06:59 +0000, Jonathan Tripathy wrote:
> >>>
> >> 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?

The title of the second HTML page is now out of date. So there is no
warm/hot confusion to worry about, just the name of the page and URL.

--
Simon Riggs http://www.2ndQuadrant.com/books/
PostgreSQL Development, 24x7 Support, Training and Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message zhong ming wu 2010-11-02 17:54:34 Re: Is this a known feature of 8.1 SSL connection?
Previous Message Grzegorz Jaśkiewicz 2010-11-02 17:26:36 Re: pg_migrator segfault