Timeline for Refresh postgres database on nightly basis
Current License: CC BY-SA 3.0
5 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Sep 2, 2016 at 6:53 | comment | added | András Váczi | Are you taking backups regardless of the dev box? If so (you should), you might want to use two dev boxes, swapping them daily. So you always have one up even during the time of the other being restored from the fresher backup. FYI, our biggest DB (8+ TB, measured on disk) needs around 4-5 hours to take a backup from (using pg_dump). | |
Sep 2, 2016 at 5:32 | answer | added | cohenjo | timeline score: 1 | |
Sep 2, 2016 at 0:18 | answer | added | Joseph Olstad | timeline score: -3 | |
Sep 2, 2016 at 0:04 | history | migrated | from serverfault.com (revisions) | ||
Sep 1, 2016 at 23:58 | history | asked | Sam | CC BY-SA 3.0 |