Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

running pg_dumpall as a cron job



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 





Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group