Re: two questions regarding warm-standby on 8.4
| От | Gary Webster |
|---|---|
| Тема | Re: two questions regarding warm-standby on 8.4 |
| Дата | |
| Msg-id | CAEHjwJ5EU5ZwwcENdq_ixFnJ3q1XxrHBnNfTiLqoVYMsU8DAyw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: two questions regarding warm-standby on 8.4 (Simon Riggs <simon@2ndQuadrant.com>) |
| Ответы |
Re: two questions regarding warm-standby on 8.4
|
| Список | 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:
Exactly. That's what Hot Standby does in 9.xOn 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?
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-admin по дате отправления: