> Guys, > > 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.
This depends what you mean by hot backup. The pg_dump utility can create a consistent database dump with no need to stop the postgresql service. But, perhaps you mean the Point in Time Recovery backup method? If so, you might look at the pgpitrha project. We haven't released any tarballs yet, but you could pull some useful scripts out of CVS. http://pgfoundry.org/projects/pgpitrha
If this doesn't get you on the right track, perhaps you can define what you mean by hot backup more precisely.