Skip site navigation (1) Skip section navigation (2)

Re: Using pgAdmin and pgAgent with Greenplum

From: "Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com>
To: 'Dave Page' <dpage(at)postgresql(dot)org>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Using pgAdmin and pgAgent with Greenplum
Date: 2007-10-31 12:15:30
Message-ID: 15362F202C62EA4590F5F3E5FA15021E052867A2@nasappexc04.int.asurion.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
> 
> > However, to make pgAgent and pgAdmin work better with my solution, it
> would
> > be nice to have an enhancement.  The enhancement could also benefit
> others
> > wanting to separate the database server where jobs are maintained from
> the
> > target server(s) where sql should be executed.
> >
> > On the screen where you define a SQL step, add another parameter for
> Server.
> > When executing the SQL defined, pgAgent would connect to the Server and
> then
> > execute the SQL defined in the database specified in the step.
> >
> > This solution would require an additional screen to define the servers
> too.
> >
> > Is there much demand for allowing a SQL job step to be executed on a
> remote
> > server and database?
> 
> I've never heard anyone ask before, but I don't think it's an
> unreasonable request. It would be more simple to just add an additional
> textbox to the SQL Step to allow a custom connection string to be
> specified. If blank it works as now, otherwise it just uses whats there.
> 
> Anyone wanna pickup this mod?
> 
> /D

There are three problems with having a custom connection string for each
step.  1) If I need to update the connection like change the password, I
have to do it for each step.  2) Developers will see the password in clear
text.  3) It is error prone because I might mistype the connection
information for a step.  

I am glad that you are interested in adding this mod and I'm glad that
PostgreSQL works so well for this.  :)


Jon

Responses

pgadmin-hackers by date

Next:From: Dave PageDate: 2007-10-31 15:02:46
Subject: Re: Using pgAdmin and pgAgent with Greenplum
Previous:From: svnDate: 2007-10-31 09:57:13
Subject: SVN Commit by mha: r6804 - branches/REL-1_8_0_PATCHES/pgadmin3/pgadmin/utils

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group