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