Re: Shell Script help for backup - Mailing list pgsql-general

From strange@nsk.yi.org
Subject Re: Shell Script help for backup
Date
Msg-id 20020723150902.A5173@nsk.yi.org
Whole thread Raw
In response to Re: Shell Script help for backup  (ratlhead@ratlhead.com (ratlhead))
List pgsql-general
On Mon, Jul 22, 2002 at 03:35:01PM -0700, ratlhead wrote:
> Hi all,
>
> This is how I ended up solving my problem.  Not sure if any of this
> will help you, but here's the scripts I use.  This is what it does...
>
> -Uses PG environmental variables to connect to the PG server
> -Dumps the specified database
> -Checks the backup folder for any backups older than a week and
> deletes those
> -Checks to be sure the backup was successful by checking for a 0k file
> for that day

What's wrong with the solution I sent?

And I doubt the checking for a 0k file will work for you as gzip will
create a 20 byte file even for a 0 byte input (some headers, etc.).

Regards,
Luciano Rocha

--
Consciousness: that annoying time between naps.

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: Stats Collector
Next
From: Barry Lind
Date:
Subject: Re: Difficulty updating TEXT fields with JDBC.