Timeline for Small databases, large backup files
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 10, 2018 at 10:12 | answer | added | TimVK | timeline score: 0 | |
| May 10, 2018 at 10:11 | comment | added | TimVK | Hi both of you. I just let my daily batch run during the night and apparently it worked just fine now with small backup files in the end. I think I was too fast in complaining/questioning. Though I can tell that I copied the line from the batch file to do the manual check and probably it added content instead of recreating the file. So that was my problem. | |
| May 9, 2018 at 16:19 | comment | added | jjanes | Something is wrong with you daily task. It is hard to debug it without seeing it. Is your daily task connecting to the database you think it is? Are there any differences between the pg_dump run manually and one run in your daily task? | |
| May 9, 2018 at 15:13 | comment | added | Patrick Mevzek | Do you have long running transactions? Is autovacuum running correctly? But to boot: did you compare the two backup files? What are the differences in them?? | |
| May 9, 2018 at 13:45 | history | edited | MDCCL | CC BY-SA 4.0 |
Added the generic tag of the DBMS at issue for visibility. Divided content into separate paragraphs. The DBMS and DBMS version are specified via tags, so I removed references from the title.
|
| May 9, 2018 at 13:43 | review | First posts | |||
| May 9, 2018 at 15:31 | |||||
| May 9, 2018 at 13:42 | history | asked | TimVK | CC BY-SA 4.0 |