Re: vacuum and backup

> 3) Has anyone written some shell scripts to do vacuum and
> backup?
> I will have to write some but am not conversant with shell
> scripts and
> would greatly appreciate any help.

You would probably be better off writing your scripts in a
system language such as Python or Perl.  Here is an excerpt from
a basic Python backup program I wrote (uses pg_dump &
postgresql-python) that does just that.

#!/usr/bin/python
import os, time
from pg import DB

# Backup database with the current date attached
def pg_backup():
    now = time.localtime(time.time())
    today = time.strftime("%m-%d-%Y", now)
    os.system("pg_dump test > test-%s.sql" % today)
    print "Backup completed"

# Run vacuum on database
def pg_clean():
    cxn = DB('test')
    cxn.query("VACUUME VERBOSE ANALYZE")
    print "Database optimized & space recovered"

### This is the main program ###
if __name__ == "__main__":
    pg_backup()
    pg_clean()

Brent

__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/