Point in time recovery?
От | |
---|---|
Тема | Point in time recovery? |
Дата | |
Msg-id | 1f67ee1f14de.1f14de1f67ee@netcom.no обсуждение исходный текст |
Ответы |
Re: Point in time recovery?
Re: Point in time recovery? |
Список | pgsql-general |
Hi! I work at a research institution (about 600 empoyees), and we are currently evaluating open source databases, particularly PostgreSQL for internal use..We currently have a multitude of commercial databases deployed (Oracle, MS SQL, Ingres, Interbase, etc.), but we would like to introduce and officially support an open source alternative to our researchers. In order to recommend and support PostgreSQL, we need to make sure that our data will be safe using PostgreSQL. I find the documentation inadequate with respect to database backup. If an error occur (hardware or software failure) we would be able to load the last backup from pg_dump. However, what about transactions that has occured after the last backup? Would we be able to roll forward to a particular point in time, so that the chances for data loss is minimal? I've heard that this feature is currently missing, but that it will be introduced in version 7.4 which should be out this year. My problem is that we cannot recommend this product unless this feature is present. If this feature won't be available until next release, is it possible to patch the current version or download a development version so that we could test that this feature really works? I really do not have much time, as we need to make a decision real soon, and without being 100% certain that PostgreSQL will meet our needs, we cannot recomment this product. I would very much appreciate any relevant information on this matter. Eivind.
В списке pgsql-general по дате отправления: