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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
