[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Debian-sf-users] sourceforge database backup

From: Mathieu Peltier
Subject: [Debian-sf-users] sourceforge database backup
Date: 03 Apr 2002 16:25:42 +0200
User-agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.1 (Cuyahoga Valley)


I am new to Debian-sf. I have read this mail of Roland Mas about sourceforge
database backup:

Why not using the pg_dump postgres command?

#! /bin/sh
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

reply via email to

[Prev in Thread] Current Thread [Next in Thread]