Chris Hoover <revoohc(at)gmail(dot)com> writes:
> Silly question, but in a shell script, what is the best way to check for a
> pg_dump problem? I'm working on reworking our backup methodology, and want
> to make sure that if pg_dump can't dump a db, we page the on call db. Does
> it return any sort of exit code indicating it was not successful dumping a
> database?
pg_dump should return nonzero exit code on failure. (At least in recent
releases ... not sure about how far back that's been done consistently.)
regards, tom lane