pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alexander Staubo <alex@purefiction.net>
To: Nimesh Satam <nimesh.zedo@gmail.com>
Cc: pgsql-performance@postgresql.org, "Nimesh Satam" <nimesh.satam@gmail.com>
Subject: Re: Warm - standby system.
Date: Tue, 24 Apr 2007 11:33:05 +0200
Message-ID: <88daf38c0704240233v766a9a25w9abb502ed585fa7a@mail.gmail.com> (raw)
In-Reply-To: <965aa3ed0704240011y9e43cbaj957005ed0ca0e8d6@mail.gmail.com>
References: <965aa3ed0704240011y9e43cbaj957005ed0ca0e8d6@mail.gmail.com>

On 4/24/07, Nimesh Satam <nimesh.zedo@gmail.com> wrote:
> Can anybody let me know the steps which are supposed to be followed to make
> the standby machine for read access? and how it should be one.

Not possible at the moment. The warm standby is not "hot" -- it cannot
be used for queries while it's acting as a standby. Explained here:

  http://www.postgresql.org/docs/8.2/static/warm-standby.html

Alexander.



view thread (2+ messages)

Message-ID: <88daf38c0704240233v766a9a25w9abb502ed585fa7a@mail.gmail.com>
Permalink:  ../88daf38c0704240233v766a9a25w9abb502ed585fa7a@mail.gmail.com/
Also on:    postgresql.org/message-id/88daf38c0704240233v766a9a25w9abb502ed585fa7a@mail.gmail.com

 · 

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-performance@postgresql.org
  Cc: alex@purefiction.net, nimesh.zedo@gmail.com, nimesh.satam@gmail.com
  Subject: Re: Warm - standby system.
  In-Reply-To: <88daf38c0704240233v766a9a25w9abb502ed585fa7a@mail.gmail.com>

* 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