From: | "Jason Tesser" <JTesser(at)nbbc(dot)edu> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Creating an hourly backup |
Date: | 2004-08-04 13:29:22 |
Message-ID: | 04875CB4331F0240A0AD66F970978651160AFF@paul |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 with the
except script, posted below. Can someone send me a working
cron or except script so I can get an hourly snapshot
of our databases?
#!/usr/bin/expect -f
###############################################
###############################################
# Script to backup PostgreSQL Database
# usage:
# ./dbbackup.exp [username] [password] [dbname] # # Use this script in a
cron job to do nightly # backups # Date format is MMHHDDMMYYYY
###############################################
###############################################
set username [lindex $argv 0]
set password [lindex $argv 1]
set database [lindex $argv 2]
set time [timestamp -format %M%H%d%m%Y]
spawn {pg_dump} -Fc --username=dbdevel
--file=/var/lib/pgsql/backups/$database.$time $database # expect
"Username:"
# send "$username\r"
expect "Password:"
send "$password\r"
expect eof
Jason Tesser
Web/Multimedia Programmer
From | Date | Subject | |
---|---|---|---|
Next Message | terry | 2004-08-04 14:21:47 | Re: Creating an hourly backup |
Previous Message | Rod Taylor | 2004-08-04 13:26:42 | Re: Tuning queries on large database |