> If you use MySQL, you have the binary log. That allows you restore any
> changes done after the last full backup(or which point  in time ever). The
> binary logfile can be saved easily every hour. It can also get moved to
> another machine, after you have cycled the logfiles.

PostgreSQL has pretty much the same feature, you can use WAL (Write
Ahead Logging) segments and move them automatically to a different
location. The if needed do a PITR (Point in Time Recovery) as described
in the documents. Works pretty neat!

Marc
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Reply via email to