I'm getting the following error on PGSQL 8.0.8 server that I admin. I don't think this is a hardware problem but I'm not sure. Anyway in the logfile I'm constantly getting this:

ERROR: xlog flush request 2/13CEA8AC is not satisfied --- flushed only to 2/13634EE4
CONTEXT:  writing block 3421 of relation 1663/9533957/9534098
WARNING:  could not write block 3421 of 1663/9533957/9534098
DETAIL:  Multiple failures --- write error may be permanent.


psql -l fails with:
psql: FATAL: xlog flush request 2/13CEA8AC is not satisfied --- flushed only to 2/13634EE4
CONTEXT:  writing block 3421 of relation 1663/9533957/9534098

but I can connect using psql DBNAME


Any insight other than restore from your most recent backup?

Thanks,

Matt

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to