Thread: Query regarding back up
How can I have a scheduled vacuum and backup of the databases in PostgreSql.
Does someone know it already?
I need it urgently.
Thanks,
Kallol.
On Thu, 17 Jul 2003, Kallol Nandi wrote: > How can I have a scheduled vacuum and backup of the databases in PostgreSql. > Does someone know it already? > I need it urgently. Use cron (I assume you're running Unix.) A simple crontab entry to run 'vacuumdb -a -z -f' and pg_dump should do. 'man crontab' is a good place to start learning about cron.
Put pg_dumpall in cron. Use vacuumdb in cron too. --------------------------------------------------------------------------- Kallol Nandi wrote: > How can I have a scheduled vacuum and backup of the databases in PostgreSql. > Does someone know it already? > I need it urgently. > > Thanks, > Kallol. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073