pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How to check for pg_dump errors?
3+ messages / 3 participants
[nested] [flat]

* How to check for pg_dump errors?
@ 2005-10-07 20:13 Chris Hoover <revoohc@gmail.com>
  2005-10-07 20:33 ` Re: How to check for pg_dump errors? Tom Lane <tgl@sss.pgh.pa.us>
  2005-10-07 20:49 ` Re: How to check for pg_dump errors? Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 2 replies; 3+ messages in thread

From: Chris Hoover @ 2005-10-07 20:13 UTC (permalink / raw)
  To: pgsql-admin

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?

Thanks,

Chris

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: How to check for pg_dump errors?
  2005-10-07 20:13 How to check for pg_dump errors? Chris Hoover <revoohc@gmail.com>
@ 2005-10-07 20:33 ` Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2005-10-07 20:33 UTC (permalink / raw)
  To: Chris Hoover <revoohc@gmail.com>; +Cc: pgsql-admin

Chris Hoover <revoohc@gmail.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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: How to check for pg_dump errors?
  2005-10-07 20:13 How to check for pg_dump errors? Chris Hoover <revoohc@gmail.com>
@ 2005-10-07 20:49 ` Peter Eisentraut <peter_e@gmx.net>
  1 sibling, 0 replies; 3+ messages in thread

From: Peter Eisentraut @ 2005-10-07 20:49 UTC (permalink / raw)
  To: Chris Hoover <revoohc@gmail.com>; +Cc: pgsql-admin

Am Freitag, 7. Oktober 2005 22:13 schrieb Chris Hoover:
> Silly question, but in a shell script, what is the best way to check for a
> pg_dump problem?

0 is success, nonzero is failure.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-10-07 20:49 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-07 20:13 How to check for pg_dump errors? Chris Hoover <revoohc@gmail.com>
2005-10-07 20:33 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-10-07 20:49 ` Peter Eisentraut <peter_e@gmx.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox