Search Postgresql Archives

Re: I can't restart postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux