pg.ddx.io  pgsql-general@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Simon Riggs <simon@2ndQuadrant.com>
To: Jonathan Tripathy <jonnyt@abpni.co.uk>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Replication
Date: Tue, 02 Nov 2010 17:32:05 +0000
Message-ID: <1288719125.1867.19438.camel@ebony> (raw)
In-Reply-To: <4CCFB6CF.4060006@abpni.co.uk>
References: <4CCF1AC4.6060800@abpni.co.uk>
	<AANLkTin8x5EruxEser40veOzq8_kGWbaQ7VkPy0H=hXM@mail.gmail.com>
	<4CCF4187.8010205@abpni.co.uk>
	<AANLkTingS59Fep3u-JoDw77oauoqu2inBffPCuCNxxdr@mail.gmail.com>
	<4CCFB6CF.4060006@abpni.co.uk>

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
 




view thread (131+ messages)  latest in thread

Message-ID: <1288719125.1867.19438.camel@ebony>
Permalink:  ../1288719125.1867.19438.camel@ebony/
Also on:    postgresql.org/message-id/1288719125.1867.19438.camel@ebony

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: simon@2ndQuadrant.com, jonnyt@abpni.co.uk, scott.marlowe@gmail.com
  Subject: Re: Replication
  In-Reply-To: <1288719125.1867.19438.camel@ebony>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox