| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jose Quiroz <soporteinterno(at)healtechnology(dot)com(dot)pe> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: I can't restart postgres |
| Date: | 2008-02-02 00:21:43 |
| Message-ID: | 18318.1201911703@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jose Quiroz <soporteinterno(at)healtechnology(dot)com(dot)pe> writes:
> 2008-02-01 17:53:33 PET PANIC: no se pudo leer el bloque 3788 de la
> relacin 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vyacheslav Kalinin | 2008-02-02 00:35:19 | Re: problem with ORDER BY |
| Previous Message | Jose Quiroz | 2008-02-01 23:39:25 | I can't restart postgres |