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

Re: two questions regarding warm-standby on 8.4

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: Gary Webster <webster(at)lexmark(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: two questions regarding warm-standby on 8.4
Date: 2012-01-23 14:52:30
Message-ID: 1327330350.8890.3.camel@lenovo01-laptop03.gunduz.org (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-admin by date

Next:From: Simon RiggsDate: 2012-01-23 14:53:11
Subject: Re: two questions regarding warm-standby on 8.4
Previous:From: Gary WebsterDate: 2012-01-23 14:48:56
Subject: two questions regarding warm-standby on 8.4

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