passionate_program...@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 sy
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
d
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_
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 Si
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/
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
On Thu, Nov 20, 2008 at 5:41 AM, Abdul Rahman <[EMAIL PROTECTED]> wrote:
> Oh!
>
> I have got the mistake made by me. Actually I didn't start the PostgreSQL
> Scheduling Agent - pgAgent service. Now its working fine.
>
> I also have attached the complete document of my work for the sake of
> knowle
Oh!
I have got the mistake made by me. Actually I didn't start the PostgreSQL
Scheduling Agent - pgAgent service. Now its working fine.
I also have attached the complete document of my work for the sake of knowledge
share.
Regards,
Abdul Rehman.
Dear all,
After installing PgAgent I have successfully created a job for auto scheduled
backup. But it is not working. I have tried both method i.e. via .bat and via
SQL. Kindly guide me and give chance to pay thanks.
Regards,
Abdul Rehman
