running pg_dumpall as a cron job

From: richard <richard(at)sheugh(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: running pg_dumpall as a cron job
Date: 2006-04-29 08:21:21
Message-ID: 20060429082121.GA15526@sheugh.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2006-04-29 20:17:08 Re: Trigger to force fields to lowercase at insert/update
Previous Message Lane Van Ingen 2006-04-28 16:59:27 Re: WAL-related Problem?