On Mon, 2012-01-23 at 09:48 -0500, Gary Webster wrote:
> 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?
Both are correct. You need to use 9.0+ to be able to read from standby.
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
In response to
pgsql-admin by date
|Next:||From: Simon Riggs||Date: 2012-01-23 14:53:11|
|Subject: Re: two questions regarding warm-standby on 8.4|
|Previous:||From: Gary Webster||Date: 2012-01-23 14:48:56|
|Subject: two questions regarding warm-standby on 8.4|