We are using EnterpriseDB PostGresql 8.3. I can't simply take a good backup because weeks have pass since the first error occurs.
I will try to Vacumm Full first, if nothing is fixed, I will try to pg_dump like you suggest. On Wed, Apr 1, 2009 at 11:49 AM, Emanuel Calvo Franco < postgres....@gmail.com> wrote: > 2009/3/31 Patrick Desjardins <mrdesjard...@gmail.com>: > > Hi, > > > > I have the error ERROR: XX001: could not read block 2354 of relation > > 1663/17633/17925: read only 0 of 8192 bytes, but only sometime, when > trying > > to Insert data into a table. I would say that 99% of Insert works and > 100% > > of read works. This is only happenning since few weeks. I have done > Vaccum > > Analyze without any success (the vaccum take 65 minutes but nothing is > > fixed, still have the ERROR XXX001). I have this error in the backend > > application and when I do some Insert Query in the PgAdmin tool. > > > > This kind of error occurs generally on 7.x versions or if you are using > fsync =off and you have a surprised system down. > > Try to do a pg_dump of the database or clean (no delete) del wal files > (this is not > recommendable for new users). > > > What can I do to fix that problem? > > > > Thank you, > > > > > > -- > Emanuel Calvo Franco > Sumate al ARPUG ! > (www.postgres-arg.org - > www.arpug.com.ar) > ArPUG / AOSUG Member > Postgresql Support & Admin >
