Re: Scheduling backup

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Scheduling backup
Date: 2010-07-02 15:05:16
Message-ID: 87vd8xzzyr.fsf@cbbrowne.afilias-int.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

passionate_programmer(at)hotmail(dot)com (RP Khare) writes:
> Is there any way to schedule PGSQL databases backups?  I want to
> take hourly dumps of my production database.

Sure.

You can use whatever tool you already have to schedule running
"pg_dump."

On Unix-like systems, you almost always have a system known as "cron"
available to you to do this.

On Windows(tm), you may have a system application called "Scheduled
Tasks" that can do the same sort of thing.
--
output = ("cbbrowne" "@" "gmail.com")
http://linuxdatabases.info/info/languages.html
HEADLINE: Suicidal twin kills sister by mistake!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Saitenheini 2010-07-02 15:13:23 Re: C-functions using SPI Missing Magic Block Error
Previous Message Tom Lane 2010-07-02 14:12:42 Re: C-functions using SPI Missing Magic Block Error