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

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group