|
Early Friday morning a bad record caused me to
reload the Thursday night pgdump backup. I performed a pgdump first to study
later. In the backup I found several incomplete transactions all done
at the end of the day. Investigating later I found the original bad record from
the Friday dump and fixed it then found that those incomplete transactions were
complete in that version.
The client shuts the system down nightly by first
closing the application then performing a pgdump on the database before shutting
it down then shuts down the computer (Windows XP PRO, PostgreSQL 8.3.3). The
pgdump would have taken place at least a couple of minutes after the application
shutdown.
I thought pgdump was suitable for a live backup of
the database. This would seem to be wrong if it dumps partial transactions. Do I
understand correctly? If so, is there something else I need to do before the
dump? Any help will be greatly appreciated. This does shake my confidence in my
backup procedures.
Thanks,
Bayless
|
