pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (22+ messages)  latest in thread

Message-ID: <BAY123-F3280C73DCD3A64CF3D0839A9F90@phx.gbl>
Permalink:  ../BAY123-F3280C73DCD3A64CF3D0839A9F90@phx.gbl/
Also on:    postgresql.org/message-id/BAY123-F3280C73DCD3A64CF3D0839A9F90@phx.gbl

 · 

reply

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