Re: I can't restart postgres - Mailing list pgsql-general

From Jose Quiroz
Subject Re: I can't restart postgres
Date
Msg-id 03F5AC8F-6E60-46A3-A27B-0C58894D3230@healtechnology.com.pe
Whole thread Raw
In response to Re: I can't restart postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: I can't restart postgres
List 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@healtechnology.com.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@healtechnology.com.pe




pgsql-general by date:

Previous
From: Ted Byers
Date:
Subject: Re: arrays of floating point numbers / linear algebra operations into the DB
Next
From: "Webb Sprague"
Date:
Subject: Re: arrays of floating point numbers / linear algebra operations into the DB