Thanks for the help.
I use the pg_resetxlog and the database start again.
Now I have other problem. I try to view a table using the command
select and I have an error and I can't view the table.
I wrote the following line in the terminal:
htpoweron=# select * from example_table;
(where example_table is one table of my database)
and I have the following message in the terminal:
ERROR: could not access status of transaction 1557774552
DETAIL: could not read from file «pg_clog/05CD» at offset 155648:
What I can do to acces that table?
Best regards
On 01/02/2008, at 07:21 PM, Tom Lane wrote:
Jose Quiroz <soporteinterno@xxxxxxxxxxxxxxxxxxxxx> writes:
2008-02-01 17:53:33 PET PANIC: no se pudo leer el bloque 3788 de la
relación 1663/17977/18281: Conseguido
Hmm, what PG version is that? This looks a bit like the results of
some
bugs that were fixed awhile ago.
I use the pgfsck but doesn't work, How I can restart the systema
again?
Well, if you don't have a recent backup to go back to, you can try
pg_resetxlog, but it's anyone's guess how consistent the database
will be afterwards. A dump/initdb/restore sequence would be a good
idea. And if you aren't on the latest release in whatever branch
you are using, now would be a good time to update.
regards, tom lane
Jose Quiroz
soporteinterno@xxxxxxxxxxxxxxxxxxxxx
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
