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. > > With version 7.3 of PostgreSQL (and the following) the data are not > recorded any more in a repertory with the name of the database, but with > the OID of the basebase. > > Do you know how I can adapt this script? > > If a developer of pg_dumpall reads this post, is it possible to add to > the command pg_dumpall an option to record one database per file? > > Regards. > > #! /bin/bash > # > for p in $(find /var/lib/postgres/data/base/ -type d -print -mindepth 1 > -maxdepth 1 ) > do > base=`basename "$p"` > pg_dump -d -f /var/backup/postgresql/dump_$base $base > done
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? -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman [EMAIL PROTECTED] LlamaLand http://netllama.linux-sxs.org ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org