Re: Query regarding back up - Mailing list pgsql-general

From scott.marlowe
Subject Re: Query regarding back up
Date
Msg-id Pine.LNX.4.33.0307211006260.15882-100000@css120.ihs.com
Whole thread Raw
In response to Query regarding back up  ("Kallol Nandi" <kallol.nandi@indussoft.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Is there a way to pass more than 32 parameters to a
Next
From: "scott.marlowe"
Date:
Subject: Re: Download of Postgres by ftp