Thread: Scheduling backup
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.
.............
Rohit Prakash
Build a bright career through MSN Education Sign up now.
use cron? On 6/30/2010 10: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/>
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
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
Rohit,
- Click on the Start-Icon (XP) or Windows-Icon(W7) to bring up your ProgrammsMenu
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
--
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.
--
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.
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!