[Debian-sf-users] sourceforge database backup

[Mathieu Peltier]

Hi

I am new to Debian-sf. I have read this mail of Roland Mas about sourceforge
database backup:
http://mail.freesoftware.fsf.org/pipermail/debian-sf-users/2002-February/000104.html

Why not using the pg_dump postgres command?

---------------------------------------
#! /bin/sh
 
DATABASE=sourceforge
BACKUP=/var/lib/sourceforge/dumps/sourceforge.dump
 
echo Saving $DATABASE database into text file: $BACKUP
mv $BACKUP.gz $BACKUP.gz.old
pg_dump $DATABASE | gzip > $BACKUP.gz
chmod 400 $BACKUP.gz
echo done
---------------------------------------

(use then
createdb sourceforge
gunzip -c sourceforge.dump.gz | psql sourceforge
to restore the postgresql database)

ps: Thanks to the authors of debian-sf package!

-- 
Mathieu Peltier