| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Richard <husttripper(at)vip(dot)sina(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Two problems when using Postgresql8.3.7, Please help me! |
| Date: | 2010-08-03 16:40:44 |
| Message-ID: | 1280853644.2025.12.camel@jd-desktop.unknown.charter.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, 2010-08-04 at 00:34 +0800, Richard wrote:
> 1.To add live HA to PG, I transfer WAL of a database instance(Primary node) to another database instance (standby node) at real time, and keep startup alive in standby node to recovery WAL online,so that standby node can be a hot standby.
> But I got some trouble. When standby node switch to primary mode to accept connections, of course after startup initilize the WAL and exit, the postgres process ereportERROR
> when mdread function enter ERROR branch, and I got message like this
> "could not read block X of relation X/X/X: read only Xof X bytes". I
> spent two days to figure out what happened, but it is too hard.Please
> help me.
What are you using to transfer the WAL?
Did you read this chapter?
http://www.postgresql.org/docs/8.3/static/continuous-archiving.html
Sincerely,
Joshua D. Drake
>
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2010-08-03 16:45:54 | Re: Two problems when using Postgresql8.3.7, Please help me! |
| Previous Message | Richard | 2010-08-03 16:34:11 | Two problems when using Postgresql8.3.7, Please help me! |