| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2012-01-23 14:53:11 | Re: two questions regarding warm-standby on 8.4 |
| Previous Message | Gary Webster | 2012-01-23 14:48:56 | two questions regarding warm-standby on 8.4 |