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

From Devrim GÜNDÜZ
Subject Re: two questions regarding warm-standby on 8.4
Date
Msg-id 1327330350.8890.3.camel@lenovo01-laptop03.gunduz.org
Whole thread Raw
In response to two questions regarding warm-standby on 8.4  (Gary Webster <webster@lexmark.com>)
List pgsql-admin
Hi,

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.

Regards,
--
Devrim GÜNDÜZ
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

Attachment

pgsql-admin by date:

Previous
From: Gary Webster
Date:
Subject: two questions regarding warm-standby on 8.4
Next
From: Simon Riggs
Date:
Subject: Re: two questions regarding warm-standby on 8.4