Re: PgAgent Job Scheduling-Backup - Mailing list pgsql-admin

From Vishal Arora
Subject Re: PgAgent Job Scheduling-Backup
Date
Msg-id BAY123-F3280C73DCD3A64CF3D0839A9F90@phx.gbl
Whole thread Raw
In response to Re: PgAgent Job Scheduling-Backup  ("Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>)
List pgsql-admin


>From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>
>To: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>,        "Vishal
>Arora" <aroravishal22@hotmail.com>,        <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


pgsql-admin by date:

Previous
From: De Leeuw Guy
Date:
Subject: Re: cache problem (v2)
Next
From: "Jayakumar_Mukundaraju"
Date:
Subject: Re: PgAgent Job Scheduling-Backup