From: "Jayakumar_Mukundaraju" <[EMAIL PROTECTED]>
To: "Ashish Karalkar" <[EMAIL PROTECTED]>, "Vishal
Arora" <[EMAIL PROTECTED]>, <pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
Date: Mon, 16 Jul 2007 19:23:20 +0530
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"
Can you run this command in psql prompt as it is shown here? I am repeatedly
telling you that this is not a SQL command. You can not run this while KIND
Is SQL. put this command in Batch file and select Kind as Batch then run it.
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@postgresql.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.
_________________________________________________________________
Don't get caught with egg on your face. Play Chicktionary!
http://club.live.com/chicktionary.aspx?icid=chick_hotmailtextlink2
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
