[...]On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot <[EMAIL PROTECTED]> wrote:
Hi,
On the PostgreSQL 6.5 server I use this shell script (see below) for the backup all of the database in several files, one file per database.
Maybe i'm just not following you, but why can't you just do: pg_dump $DBNAME >$DB_NAME
where $DB_NAME is the name of each database on the box?
This script is called in a crontab the every day at 6 o'clock in the morning.
-- ============================================== | FREDERIC MASSOT | | http://www.juliana-multimedia.com | | mailto:[EMAIL PROTECTED] | ===========================Debian=GNU/Linux===
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster