-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Why don't you just use a simple shell script run via cron.hourly:
#!/bin/sh
cd /opt/backups
pg_dump -R -O -a -i -Umyuser mydatabase > db_backup`date +'%Y%m%d'`.sql
gzip --best *.sql
I'm using the above for a daily backup in /etc/cron.daily. Look at
EMAIL PROTECTED]
Fax: (416) 441-9085
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Jason Tesser
> Sent: Wednesday, August 04, 2004 9:29 AM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] Creating an hourly backup
>
>
> I am trying t
I am trying to get an hourly backup of postgres. I tried using the
script below
but when I try to restore off the dumped file it throws an error that
says it
cannot read the data [-1]. If I just type in pg_dump -Fc --file=***
username= database
it restores fine. So something is going on wi
