Timeline for Automate Database backup in PostgreSQL
Current License: CC BY-SA 3.0
Post Revisions
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 13, 2019 at 16:26 | answer | added | Rajan jha | timeline score: 1 | |
| Dec 11, 2015 at 10:08 | vote | accept | Shruthi | ||
| Dec 11, 2015 at 9:15 | comment | added | Shruthi | When we create a sql backup, and then try to restore the same in PostgreSql , it doesnt support it. | |
| Dec 11, 2015 at 7:23 | comment | added | frlan | Just wondering: Why is *.sql not suitable as it is some kind of backup? What do you want to achieve and why didn't you post this question on dba.stackexchange.com or superuser.com | |
| Dec 11, 2015 at 7:22 | history | edited | frlan | CC BY-SA 3.0 |
edited body; edited title
|
| Dec 11, 2015 at 7:03 | answer | added | Vivek S. | timeline score: 6 | |
| Dec 11, 2015 at 6:04 | comment | added | Vivek S. | Try this - hastebin.com/ajocisifep.dos | |
| Dec 11, 2015 at 6:03 | comment | added | Shruthi | 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. | |
| Dec 11, 2015 at 6:02 | comment | added | Vivek S. |
and when comes to scheduling you can simply use windows Schedule Task , here is an example thewindowsclub.com/…
|
|
| Dec 11, 2015 at 6:01 | comment | added | Vivek S. | 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 ?? | |
| Dec 11, 2015 at 6:00 | comment | added | Shruthi | Yes, schedule a process to take the backup. | |
| Dec 11, 2015 at 5:58 | comment | added | Vivek S. | So you just want automate postgresql backup like scheduling the backup or what ?? | |
| Dec 11, 2015 at 5:56 | history | asked | Shruthi | CC BY-SA 3.0 |