Re: Scheduling backup

From: Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>
To: RP Khare <passionate_programmer(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Scheduling backup
Date: 2010-06-30 12:12:24
Message-ID: 4C2B34A8.6000207@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 30/06/10 8:37 AM, RP Khare wrote:
> Is there any way to schedule PGSQL databases backups? I want to take
> hourly dumps of my production database.
>
> .............
> Rohit Prakash
>
> ------------------------------------------------------------------------
> Build a bright career through MSN Education Sign up now.
> <http://education.in.msn.com/>

You can use Crontab (linux)/Schedule Jobs(Windows).

With this if you want then your can use pgagent for scheduling Jobs.
For more information on pgagent, please refer following link:
http://www.pgadmin.org/docs/1.4/pgagent.html

--
Thanks& Regards,
Vibhor Kumar.
EnterpriseDB Corporation
The Enterprise Postgres Company

Office: 732-331-1300 Ext-2022

Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com
Follow us on Twitter: http://www.twitter.com/enterprisedb

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrea Lombardoni 2010-06-30 12:51:37 Problem with temporary tables
Previous Message stanimir petrov 2010-06-30 09:52:11 pgpool2 + slony 1 in master/slave mode with no load balance and no select replication - slaves handle all reads