I have the same thing in PHP if someone needs it. I wrote it originally
to get around the limits of 7.3's pg_dumpall to hit against our 7.2
production database, and then got carried away and did the same thing as
you, made it dump them into seperate files.
For folks with lots of databases (we create a different database for each
discrete application) it's nice to have individual database dumps instead
of the one huge file that pg_dumpall makes.
Now that it's getting re-written in C, it might be a good time to add the
ability to create a file per each database...
On Tue, 10 Jun 2003, Andrew Gould wrote:
> I have cron execute a Python script as the database
> administrator to vacuum and backup all databases.
> Rather than dump all databases at once, however, the
> script performs a 'pgsql -l' to get a current list of
> databases. Each database is dumped and piped into
> gzip for compression into its own backup file.
>
> I should also mention that the script renames all
> previous backup files, all ending in *.gz, to
> *.gz.old; so that they survive the current pg_dump.
> Of course, you could change the script to put the date
> in the file name as to keep unlimited backup versions.
>
> If you'd like the script, let me know.
>
> Best of Luck,
>
> Andrew L. Gould
>
> --- Robert Fitzpatrick <robert@webtent.com> wrote:
> > I'm looking for an unattended (cron job) to dump all
> > the databases. We
> > have both 7.3.3 and 7.0.2 (Cobalt RaQ) to do this
> > for. I cannot grant a
> > certain user permission to dump the databases in
> > 7.0.2 pg_hba.conf file
> > and, if I do this for our 7.3.3, does it mean anyone
> > at the command
> > prompt can access the databases using the '-U'
> > option and it not require
> > a password? What are most on this list doing for
> > automated dumps?
> >
> > --
> > Robert
> >
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please
> > send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org
> > so that your
> > message can get through to the mailing list cleanly
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
