Re: pg_dump "what if?"

Thanks, but I'm calling a win32 compiled version of pg_dump, which runs
asynchronously to the rest of my code (sorry I was vague in my first
message). As such, I don't see how I can use the return value. My only
other thought was to check for the existence of the file, which would be
useless if the file represented an incomplete dump.

-----Original Message-----
From: Dustin Sallings [mailto:dustin(at)spy(dot)net]
Sent: March 24, 2004 1:26 PM
To: Anony Mous
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] pg_dump "what if?"

On Mar 24, 2004, at 11:42, Anony Mous wrote:

I'm running pg_dump 7.3.4. I have a nightly process that dumps a database
via pg_dump, and then checks for the existence of the dumped file afterwards
to confirm that the dump actually occurred. Just wondering, however, if a
corrupt disk prevented pg_dump from executing fully, would there still be an
output file up to the point where the corruption was encountered? If so,
does anyone have any suggestions on another method to confirm whether or not
the db was successfully dumped?

The exit code?

--
Dustin Sallings