From: | Jose Quiroz <soporteinterno(at)healtechnology(dot)com(dot)pe> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: I can't restart postgres |
Date: | 2008-02-02 05:49:13 |
Message-ID: | 03F5AC8F-6E60-46A3-A27B-0C58894D3230@healtechnology.com.pe |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
The version of postgres is 8.1
And i don't have any backup of the system, I think that could be a
problem to restore the system.
thanks for answer.
regards, jose
On 01/02/2008, at 07:21 PM, Tom Lane wrote:
> 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
>> 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(at)healtechnology(dot)com(dot)pe
From | Date | Subject | |
---|---|---|---|
Next Message | Webb Sprague | 2008-02-02 06:11:54 | Re: arrays of floating point numbers / linear algebra operations into the DB |
Previous Message | Ted Byers | 2008-02-02 05:47:45 | Re: arrays of floating point numbers / linear algebra operations into the DB |