Postgres Pro
Downloads
Home   >   mailing lists

running pg_dumpall as a cron job - Mailing list pgsql-novice

From richard
Subject running pg_dumpall as a cron job
Date
Msg-id 20060429082121.GA15526@sheugh.com
Whole thread Raw
Responses Re: running pg_dumpall as a cron job  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-novice
Tree view 
Hi all

I am trying to run pg_dumpall as a cron job. I find that while
pg_dump has an option -f to name a file for output this is
not available for pg_dumpall. After reading the manual, my
guess is that best practice is to run pg_dump for each database.

Is there a preferred way of routinely saving all your
databases via pg_dump or pg_dumpall?

TIA

Richard A Lough

pgsql-novice by date:

Previous
From: Leonardo Boiko
Date:
Subject: Trigger to force fields to lowercase at insert/update
Next
From: Andreas Kretschmer
Date:
Subject: Re: Trigger to force fields to lowercase at insert/update