Re: PgAgent Job Scheduling-Backup

Dear Vishal / Ashish

I did these steps only...

1. I get the pgAgent.sql script in pgAdmin III directory , I copied that scripts and execute the scripts in my default postgres database.

2. After, I get the jobs icon in our postgres.

3. In that jobs icon I given jobs name,schedule name and steps

In steps tab I given the step name , Enabled, Database name

Kind : SQL , On error is: Fail

Comment : postgres backup

In definition box : I given this command pg_dump postgres "D:\AGBACKUP\AG.sql"

These steps only I did it...

Thanks & Regards
Jayakumar M

________________________________

From: Jayakumar_Mukundaraju
Sent: Mon 7/16/2007 6:19 PM
To: Ashish Karalkar; Vishal Arora; pgsql-admin(at)postgresql(dot)org
Subject: RE: [ADMIN] PgAgent Job Scheduling-Backup

Dear Vishal/Ashish

In my pgpass.conf file there is two password is there.. both the passwords are same
Host Port Database UserName Password
localhost: 5432: postgres: postgres: satyam123$
localhost: 5432: *: postgres: satyam123$

Thanks & Regards
Jayakumar M

DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.