Horton

Thread

  1. pg_dump return status..

    Anand Raman <araman@india-today.com> — 2001-01-04T10:12:25Z

    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

  2. Re: pg_dump return status..

    Anthony E . Greene <agreene@pobox.com> — 2001-01-05T05:06:17Z

    On Thu, 04 Jan 2001 05:12:25 Anand Raman wrote:
>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..

You could have the script check for the existence of the dump file and that
it has a non-zero size. To dump my personal database, I could use this:

#!/bin/bash
dumpfile=$HOME/mydatabase.dump
pg_dump -d $LOGNAME > $dumpfile
if [ -s $dumpfile ] ; then
  echo 'Dump succeeded'
else
  echo 'Dump failed'
fi

This should work in sh also.

Tony
-- 
Anthony E. Greene <agreene@pobox.com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
Chat:  AOL/Yahoo: TonyG05    ICQ: 91183266
Linux. The choice of a GNU Generation. <http://www.linux.org/>