Re: beta testing version
От | xuyifeng |
---|---|
Тема | Re: beta testing version |
Дата | |
Msg-id | 002501c059ff$f1c49a20$e001a8c0@xyf обсуждение исходный текст |
Ответ на | AW: beta testing version (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>) |
Список | pgsql-hackers |
----- Original Message ----- From: Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at> Subject: AW: [HACKERS] beta testing version > > > NO, I just tested how solid PgSQL is, I run a program busy inserting record into PG table, when I > > suddenly pulled out power from my machine and restarted PG, I can not insert any record into database > > table, all backends are dead without any respone (not core dump), note that I am using FreeBSD 4.2, > > it's rock solid, it's not OS crash, it just losted power. > > PostgreSQL Versions 7.0 and below have the potential of corruting indices when the system crashes. > The usual procedure would be to reindex the database. Hiroshi has written code to allow this. > It is weird, that your installation blocks. Have you checked the postmaster log ? > REINDEX command failed, I have an unique index, PG claimed there were two records have same key, but obviously, it's not the fact. >[snip] > Yes, this is a test I would also do before putting very sensitive data onto a particular brand of database. > > Fortunately Version 7.1 of PostgreSQL will live up to your expectations in this area. > > Andreas > Thanks, --- XuYifeng
В списке pgsql-hackers по дате отправления: