Re: Pg_dumpall

From: Andrew Gould <andrewgould(at)yahoo(dot)com>
To: Robert Fitzpatrick <robert(at)webtent(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Pg_dumpall
Date: 2003-06-10 11:10:12
Message-ID: 20030610111012.9732.qmail@web13406.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)webtent(dot)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(at)postgresql(dot)org
> so that your
> message can get through to the mailing list cleanly

In response to

  • Pg_dumpall at 2003-06-09 02:04:26 from Robert Fitzpatrick

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ned Lilly 2003-06-10 12:46:54 Re: [GENERAL] MySQL gets $19.5 MM
Previous Message Csaba Nagy 2003-06-10 10:06:49 Re: viewing the original (chrnological) order of entered