Skip site navigation (1) Skip section navigation (2)

two questions regarding warm-standby on 8.4

From: Gx <gx(dot)webster(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: two questions regarding warm-standby on 8.4
Date: 2012-01-23 14:37:29
Message-ID: CAFEsAGwS=b=vG6PHvBcGCzc4WxbfAoof8XMtiAJ1Gy8hoFkHyQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hello.

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?

Thanks.
Gx

pgsql-admin by date

Next:From: Gary WebsterDate: 2012-01-23 14:48:56
Subject: two questions regarding warm-standby on 8.4
Previous:From: Al-Salami, AdelDate: 2012-01-23 13:56:09
Subject: "service user account 'postgres' could not be created"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group