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

From Kevin Grittner
Subject Re: two questions regarding warm-standby on 8.4
Date
Msg-id 4F2D57B50200002500044DCA@gw.wicourts.gov
Whole thread Raw
In response to two questions regarding warm-standby on 8.4  (Gx <gx.webster@gmail.com>)
List 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 by date:

Previous
From: jdmorgan
Date:
Subject: Re: case statement to cath nulls on joined tables
Next
From: Andrew Barinov
Date:
Subject: Starting postgres server on mac os x 10.6.8