Re: Shell Script help for backup

From: strange(at)nsk(dot)yi(dot)org
To: ratlhead <ratlhead(at)ratlhead(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Shell Script help for backup
Date: 2002-07-23 14:09:02
Message-ID: 20020723150902.A5173@nsk.yi.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Joseph Krogh 2002-07-23 14:13:09 Re: Editor for pgsql
Previous Message Jan Wieck 2002-07-23 14:05:28 Re: Stats Collector