Scheduling backup

use cron?

In response to RP Khare :

Is there any way to schedule PGSQL databases backups? I want to take hourly
dumps of my production database.

You can use the OS-scheduler, for instance, CRON for UNIX-like systems.

Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99

Rohit,

yes, there is.

- Click on the Start-Icon (XP) or Windows-Icon(W7) to bring up your
ProgrammsMenu
- click on "Control Panel"
- click on administration icon
- DOUBLE-CLICK on planned tasks
- click on new planned tasks, in the add planned task wizzard you can add
the commands for running pg_dump
- to learn more about the PostgreSQL PG_DUMP utility, please read up on
http://developer.postgresql.org/pgdocs/postgres/app-pgdump.html

best wishes,

Harald

On Wed, Jun 30, 2010 at 09:37, RP Khare
<passionate_programmer@hotmail.com>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/&gt;

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
Using PostgreSQL is mostly about sleeping well at night.

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
Using PostgreSQL is mostly about sleeping well at night.

On 06/30/10 12:37 AM, RP Khare wrote:

Is there any way to schedule PGSQL databases backups? I want to take
hourly dumps of my production database.

if those are your backup requirements, you should take a look at PITR,
Point In Time Recovery, where you take just an occasional full database
dump, then archive WAL logs which record the changes to the database,
minute by minute.

these logs can be used to play back the database transactions to any
specific Point In Time.

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/&gt;

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

passionate_programmer@hotmail.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!