pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Warm - standby system.
2+ messages / 2 participants
[nested] [flat]

* Warm - standby system.
@ 2007-04-24 07:11  Nimesh Satam <nimesh.zedo@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Nimesh Satam @ 2007-04-24 07:11 UTC (permalink / raw)
  To: pgsql-performance@postgresql.org, "Nimesh Satam" <nimesh.satam@gmail.com>

Hi,


I tried to create a standby system as per the steps mentioned in the
following article

http://archives.postgresql.org/sydpug/2006-10/msg00001.php.

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.


Also it will be helpful if you can let me know what care needs to be taken
to implement this in production.


Regards,
Nimesh.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Warm - standby system.
@ 2007-04-24 09:33  Alexander Staubo <alex@purefiction.net>
  parent: Nimesh Satam <nimesh.zedo@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Alexander Staubo @ 2007-04-24 09:33 UTC (permalink / raw)
  To: Nimesh Satam <nimesh.zedo@gmail.com>; +Cc: pgsql-performance@postgresql.org, "Nimesh Satam" <nimesh.satam@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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-04-24 09:33 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-04-24 07:11 Warm - standby system. Nimesh Satam <nimesh.zedo@gmail.com>
2007-04-24 09:33 ` Alexander Staubo <alex@purefiction.net>

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