Re: [GENERAL] I can't restart postgres

2008-02-04 Thread Jose Quiroz
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 e

Re: [GENERAL] I can't restart postgres

2008-02-01 Thread Scott Marlowe
On Feb 1, 2008 11:49 PM, Jose Quiroz <[EMAIL PROTECTED]> wrote: > 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. 8.1.what? ---(end of broadcast)--- TIP 5: don't fo

Re: [GENERAL] I can't restart postgres

2008-02-01 Thread Jose Quiroz
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 <[EMAIL PROTECTED]> writes: 2008-02-01 17:53:33 PET PANIC: no se pud

Re: [GENERAL] I can't restart postgres

2008-02-01 Thread Tom Lane
Jose Quiroz <[EMAIL PROTECTED]> 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, H

[GENERAL] I can't restart postgres

2008-02-01 Thread Jose Quiroz
I need help to start the postgres. The server was shutdown improperly and after that we can't restart the postgres. Here is the log that show in the screen when I try to start the postgres. The log is in spanish, but at the end I write the log in english. Starting PostgreSQL 8.1 database s