Timeline for Does running pg_dump on live db produce consistent backups?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 9, 2015 at 12:02 | comment | added | András Váczi | Your statements are either indicating a serious bug (did you file a bug report?), a serious bug in the way you dump your database or some misunderstanding. Lacking any facts one cannot decide among these. | |
| Jul 9, 2015 at 11:53 | comment | added | Dennis Nolte | You can trust pg_dump to do a serialized backup (see my answer for links/docs and a few details) However during my readings i did read that you should not change the structure of the DB itself, though i was unable to dig deeper on that. As we only do insert/update/delets i cannot comment on table creations. For us i just made sure to not create tables during the pg_dump time. | |
| May 27, 2015 at 17:19 | review | Late answers | |||
| May 27, 2015 at 17:23 | |||||
| May 27, 2015 at 17:02 | comment | added | Roman | If that happens it would be a serious in pg_dump. What version you're using? My question was 3 years ago, and now I'm on 9.3 and Amazon reds which does live backups apparently using pg_dump. They can't be wrong. | |
| May 27, 2015 at 17:02 | review | First posts | |||
| May 27, 2015 at 19:34 | |||||
| May 27, 2015 at 17:00 | history | answered | Pete Porter | CC BY-SA 3.0 |