pgdump problem or question?

From: "Bayless Kirtley" <bkirt(at)cox(dot)net>
To: "List, Postgres" <pgsql-general(at)postgresql(dot)org>
Subject: pgdump problem or question?
Date: 2008-09-10 21:31:11
Message-ID: 002701c9138c$8dc90340$6501a8c0@Desktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reece Hart 2008-09-10 21:43:53 Re: PostgreSQL process architecture question.
Previous Message Ben Kim 2008-09-10 20:55:34 Re: [GENERAL] FW: How to upload data to postgres