From: Vishal Arora <aroravishal22@hotmail.com>
To: Jayakumar_Mukundaraju@satyam.com
To: ashish.karalkar@info-spectrum.com
To: pgsql-admin@postgresql.org
Subject: Re: PgAgent Job Scheduling-Backup
Date: Tue, 17 Jul 2007 04:13:52 +0000
Message-ID: <BAY123-F3280C73DCD3A64CF3D0839A9F90@phx.gbl> (raw)
In-Reply-To: <8BE2E1772BEE8D40B0FB9E59DF2A645E04C4E89A@hcsmsg002.corp.satyam.ad>
>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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: aroravishal22@hotmail.com, Jayakumar_Mukundaraju@satyam.com, ashish.karalkar@info-spectrum.com
Subject: Re: PgAgent Job Scheduling-Backup
In-Reply-To: <BAY123-F3280C73DCD3A64CF3D0839A9F90@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox