I think postgres 8.1 onwards gives hot backup facility, i was searching on net for an automated script to do that for me. But i cannot find any. Has anyone written a script to do something like that automated on linux.
If anyone has written and tested, i would appricate if you can share it with me.