Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

8
  • So you just want automate postgresql backup like scheduling the backup or what ?? Commented Dec 11, 2015 at 5:58
  • Yes, schedule a process to take the backup. Commented Dec 11, 2015 at 6:00
  • It did take the backup, but the file generated was a sql file, though i did change the extension to .backup. As a result, if i need to restore the DB, and try to restore from the file generated it is not possible dont you need a solution for this ?? Commented Dec 11, 2015 at 6:01
  • and when comes to scheduling you can simply use windows Schedule Task , here is an example thewindowsclub.com/… Commented Dec 11, 2015 at 6:02
  • Yes, See i found this script which helps me to automate a backup which includes the process of Taskscheduling and other stuff. As of now my problem is that i am not able to generate a ".backup" file, all i can do is a ".sql" file. Commented Dec 11, 2015 at 6:03