Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

regular backup

Status
Not open for further replies.

keak

Programmer
Sep 12, 2005
247
CA
Hi there, I was wondering if you have any good recoomendation for the method used to back up postgres databases regularly (automated running in certain intervals), with timestamps on the filename. This automated process will run every day at a secific time.
 
Hi Keak,

We used to run a cron job that ran a batch file that backed postgres up to a local dir and added the timestamp to the filename.
We ended up running the backup every 15 mins and it worked like a charm.

If you want an automated process that runs every day at a specified time then cron is what you need.

You are running on linux aren't you ?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top