Re: How robust is postgresql ?
От | Simon Crute |
---|---|
Тема | Re: How robust is postgresql ? |
Дата | |
Msg-id | 022401c0a74b$8b0573b0$0419a8c0@rimmer обсуждение исходный текст |
Ответ на | Re: How robust is postgresql ? ("Brett W. McCoy" <bmccoy@chapelperilous.net>) |
Список | pgsql-general |
Thanks for the answer, (and thanks to adb too) > > 7.1 has write-ahead logging (WAL), which does what you are looking for. > See http://www.postgresql.org/devel-corner/docs/admin/wal.html > > The fsync mode also helps with data integiry, but it *really* slows down > the system, unfortunately. Looks like WAL is what we want. I understand that 7.1 should be out in a few weeks ? > > The other question is Backups. Is there anyway to take diferential backups ? > > I.E do a full dump periodically, and then make diferential backups from time > > to time (preferably to a differet box) > > You can do a database dump and back up the SQL generated, or do a > filesystem backup. See > http://www.postgresql.org/devel-corner/docs/admin/backup.html for > information on the specifics. I was looking for ways of backing up only data that had changed since the last backup. The server will probably be hosted with an ISP so I don't want unnecessary data transfers.
В списке pgsql-general по дате отправления: