Re: Help using pgfsck
От | Vilson farias |
---|---|
Тема | Re: Help using pgfsck |
Дата | |
Msg-id | 00af01c30441$fb8a3530$98a0a8c0@dgtac обсуждение исходный текст |
Ответ на | Help using pgfsck ("Vilson farias" <vilson.farias@digitro.com.br>) |
Список | pgsql-general |
Greetings, I found a way to fix this kind of database corruption. It seems only invalid tuples cause database shutdown. I just did a lot of selects until I found all of these tuples(just 1 in this case). After deletion of invalid records my database is running again :). Just in case, I'm dumping/restoring the entire database to make sure new one doesn't has any problems. I would like to thanks people that helped me, especially Mr. Oosterhout who gave me a lot of valuable information. Mr. Alex B, datetime type really existis (at least here in my PostgreSQL 7.1.2). Maybe it's an alias for timestamp type, but I'm not sure. Best regards. ----- Original Message ----- From: "Martijn van Oosterhout" <kleptog@svana.org> To: "Vilson farias" <vilson.farias@digitro.com.br> Cc: <pgsql-general@postgresql.org>; <ricardo.klava@digitro.com.br> Sent: Tuesday, April 15, 2003 8:20 PM Subject: Re: [GENERAL] Help using pgfsck
В списке pgsql-general по дате отправления: