Re: need help for PostgreSQL consistency check mechanism
| От | Filip Rembiałkowski |
|---|---|
| Тема | Re: need help for PostgreSQL consistency check mechanism |
| Дата | |
| Msg-id | 92869e660904240953t2a93a61dp8cf0a503efb8a9aa@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: need help for PostgreSQL consistency check mechanism ("Joshua D. Drake" <jd@commandprompt.com>) |
| Ответы |
Re: need help for PostgreSQL consistency check mechanism
|
| Список | pgsql-general |
2009/4/24 Joshua D. Drake <jd@commandprompt.com>
That is just a bad habit from MySQL world. People just don't understand that all possible recovery is handled by postgres itself.
OTOH, there could be some consistency check method... If postgres had block- or row-level checksums, this could do.
The best way I know is to do plain pg_dumpall. But this does not detect all data corruptions.
On Fri, 2009-04-24 at 10:04 -0400, Alvaro Herrera wrote:That doesn't make sense at all.
> Chen, Dongdong (GE Healthcare) escribió:
> >
> > When the OS starts up, it wants to detect whether there is data loss
> > in PostgreSQL from last shutdown, is there a method provided?
>
> Why would the OS want to do that?
That is just a bad habit from MySQL world. People just don't understand that all possible recovery is handled by postgres itself.
OTOH, there could be some consistency check method... If postgres had block- or row-level checksums, this could do.
The best way I know is to do plain pg_dumpall. But this does not detect all data corruptions.
--
Filip Rembiałkowski
JID,mailto:filip.rembialkowski@gmail.com
http://filip.rembialkowski.net/
В списке pgsql-general по дате отправления: