Re: Two problems when using Postgresql8.3.7, Please helpme!

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
initilizethe 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