Re: pg_dump "what if?" - Mailing list pgsql-general

From Anony Mous
Subject Re: pg_dump "what if?"
Date
Msg-id 000f01c411e2$4a66aae0$7402a8c0@PETER
Whole thread Raw
In response to Re: pg_dump "what if?"  (Dustin Sallings <dustin@spy.net>)
Responses Re: pg_dump "what if?"
Re: pg_dump "what if?"
List pgsql-general

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@spy.net]
Sent: March 24, 2004 1:26 PM
To: Anony Mous
Cc: pgsql-general@postgresql.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

pgsql-general by date:

Previous
From: günter strubinsky
Date:
Subject: ERROR: column "currec" does not exist while calling function with 'record' (or %rowtype% argument
Next
From: David Garamond
Date:
Subject: PG's table inheritance and object table in Oracle