Re: two questions regarding warm-standby on 8.4

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: two questions regarding warm-standby on 8.4
Дата
Msg-id 4F2D57B50200002500044DCA@gw.wicourts.gov
обсуждение исходный текст
Ответ на two questions regarding warm-standby on 8.4  (Gx <gx.webster@gmail.com>)
Список pgsql-admin
Gx  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?

Sounds right on all counts to me.  Starting with 9.0 you can have a
hot standby which can be queried while it is the replication target.

-Kevin

В списке pgsql-admin по дате отправления:

Предыдущее
От: jdmorgan
Дата:
Сообщение: Re: case statement to cath nulls on joined tables
Следующее
От: Andrew Barinov
Дата:
Сообщение: Starting postgres server on mac os x 10.6.8