Re: two questions regarding warm-standby on 8.4 - Mailing list pgsql-admin

From Gary Webster
Subject Re: two questions regarding warm-standby on 8.4
Date
Msg-id CAEHjwJ5EU5ZwwcENdq_ixFnJ3q1XxrHBnNfTiLqoVYMsU8DAyw@mail.gmail.com
Whole thread Raw
In response to Re: two questions regarding warm-standby on 8.4  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: two questions regarding warm-standby on 8.4  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-admin
Hello.
Thanks for the informative replies.

So, is Hot Standby the recommended way to do HA?
My application does not need to be able to do queries on the standby.


On Mon, Jan 23, 2012 at 9:53 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
On Mon, Jan 23, 2012 at 2:48 PM, Gary Webster <webster@lexmark.com> wrote:

> I am configuring warm-standby as documented here:
> http://www.postgresql.org/docs/8.4/interactive/warm-standby.html
>
> I am using "pg_standby", & may have it working corrrectly, but am not sure.
>
> 1)  The standby database never 'starts', right? (/etc/init.d/postgresql-8.4
> start" times out; I can't connect to the db to see if tables are correct).
>
> 2)  Because of #1, I suppose I can't do a pg_dump on the standby db?

Exactly. That's what Hot Standby does in 9.x

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

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Best practise for upgrade of 24GB+ database
Next
From: Simon Riggs
Date:
Subject: Re: two questions regarding warm-standby on 8.4