I posted a note to the hackers list about this very issue last week. It was
never responded to. I am prepared to do the work and submit a patch, but I
wanted some input on how best to do it. We had a problem with a backup
script silently failing when the disk was full. I guess I will get started
on it and will get feedback on the patch when it's submitted.
Matt
> -----Original Message-----
> From: Anand Raman [SMTP:araman@india-today.com]
> Sent: Thursday, January 04, 2001 4:12 AM
> To: postgresql
> Subject: [GENERAL] pg_dump return status..
>
> hi guys
>
> I am trying to create a shell script which dumps my db to a flat file ..
>
> To dump the database i use the pg_dump command..
>
> I find that irrespective of the fact whether pg_dump managed to connect
> to the db or not the return status ($?) is always zero.. This throws the
> shell script in a spin which continues even when pg_dump is not able to
> connect ..
>
> Is there anyway around this. I thought of one way was to check stderr
> for the occurence of the word "failed" and then exit..
>
> Ur suggestions are most welcome
>
> version postgresql 702
>
> Regards
> Anand Raman
>