Good day, We are planning to do a grand-father/father/son back-up (from live-db) and restore (it to master-db) our daily transaction, then delete/purge the data (on our live).
According to our DBA, postgreSQL is not capable of doing it, and I don't agree with him.
i dont think so either, coz postgresql, etc. cant do it alone...
Is there a way to implement our plan? Sample script,documentation or web site on how to do this is highly appreciated. Thank you very much.
check this out
BASTRAMA ( http://bastrama.sourceforge.net )
a command-line tool to manage backup files that are stored on random
access memory (eg. hard drives). It implements an infinite grandfather-father-son
strategy by deleting a defined subset of the backup files, therefore saving storage
space while still keeping some of the older backups in case something went wrong
*would you be kind enough to post your config after
you've installed it succesfully?
thanks!
