Hi<br /><br />Can someone help me how to repair the problem below, I'm using Postgres 8.2.5:<br />- after appeared the
errosbelow in selects, vacuum and dump in one table:<br />2009-10-16 16:07:06 BRT 192.168.0.87 ERROR: could not access
statusof transaction 29024764<br /> 2009-10-16 16:07:06 BRT 192.168.0.87 DETAIL: Could not open file "pg_clog/001B":
Nosuch file or directory.<br /> 2009-10-16 16:07:06 BRT 192.168.0.87 STATEMENT: select ...<br />2009-10-16 16:11:47
BRT192.168.0.29 ERROR: invalid page header in block 462821 of relation "..."<br />2009-10-16 16:11:47 BRT 192.168.0.29
STATEMENT: select ....<br /> I created the file pg_clog/001B with 256kB of /dev/zero <br />That resolve the problem
withvacuum but began other error in selects and dump to the same table ended all connections and stay up after showing
theerror:<br /> 2009-10-19 13:50:03 BRT LOG: server process (PID 1544) was terminated by signal 11<br />2009-10-19
13:50:03BRT LOG: terminating any other active server processes<br />2009-10-19 13:50:03 BRT 192.168.0.253 WARNING:
terminatingconnection because of crash of another server process<br /> 2009-10-19 13:50:03 BRT 192.168.0.253 DETAIL:
Thepostmaster has commanded this server process to roll back the current transaction and exit, because another server
processexited abnormally and possibly corrupted shared memory.<br /> 2009-10-19 13:50:03 BRT 192.168.0.253 HINT: In a
momentyou should be able to reconnect to the database and repeat your command.<br />Was habilited the zero_damage_pages
optionthen executed selects, vacuums, and dumps but not changed...<br />Was identified 2 register that if refered cause
error.<br/><div class="gmail_quote">The BD was restored in backup server with 8.2.7 and executed vacuums ok but select
andreindex crashed...<br /></div><div class="gmail_quote"><font color="#888888"><font color="#000000">Instaled 8.3.8
versionand used pg_dump but error</font></font></div><div class="gmail_quote">And then the select below show the
problemwhere the codentrega from where clause differ from select answer:<br /></div><font color="#888888">LOGIST=#
selectcodentrega from entregas where codentrega='9879622';<br /> codentrega<br />------------<br /> z879622<br />(1
registro)<br/></font><br />Any idea?<br />
