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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
