Re: Query regarding back up

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Kallol Nandi <kallol(dot)nandi(at)indussoft(dot)com>
Cc: Pgsql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Query regarding back up
Date: 2003-07-21 16:07:21
Message-ID: Pine.LNX.4.33.0307211006260.15882-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kathy Zhu 2003-07-21 16:10:48 Re: Incomprehensible behaviour of a foreign key.
Previous Message scott.marlowe 2003-07-21 16:04:59 Re: Is there a way to pass more than 32 parameters to a