Postgres Pro
Downloads
Home   >   mailing lists

Thread: CVS Commit by dpage: Use schema 'pgadmin' as PostgreSQL makes it

CVS Commit by dpage: Use schema 'pgadmin' as PostgreSQL makes it

From
cvs@developer.pgadmin.org
Date:
Log Message:
-----------
Use schema 'pgadmin' as PostgreSQL makes it difficult to create schemas starting with pg_.
Remove dependencies on oids. (Basically untested at this time)

Modified Files:
--------------
    pgagent:
        pgagent.sql (r1.2 -> r1.3)
    pgagent/src:
        connection.cpp (r1.1 -> r1.2)
        job.cpp (r1.2 -> r1.3)
        pgAgent.cpp (r1.2 -> r1.3)
        pgAgent.dsp (r1.3 -> r1.4)
    pgagent/src/include:
        connection.h (r1.1 -> r1.2)
        job.h (r1.1 -> r1.2)
Attachment

Re: CVS Commit by dpage: Use schema 'pgadmin' as

From
Raphaël Enrici
Date:
cvs@developer.pgadmin.org wrote:
> Log Message:
> -----------
> Use schema 'pgadmin' as PostgreSQL makes it difficult to create schemas starting with pg_.
> Remove dependencies on oids. (Basically untested at this time)
>
> Modified Files:
> --------------
>     pgagent:
>         pgagent.sql (r1.2 -> r1.3)
>     pgagent/src:
>         connection.cpp (r1.1 -> r1.2)
>         job.cpp (r1.2 -> r1.3)
>         pgAgent.cpp (r1.2 -> r1.3)
>         pgAgent.dsp (r1.3 -> r1.4)
>     pgagent/src/include:
>         connection.h (r1.1 -> r1.2)
>         job.h (r1.1 -> r1.2)

Hi Dave,
(thanks for the tip concerning wx2.5.4 DL, the links are up to date now
on wxwidgets' site.)
may I ask for a short explanation concerning pgagent? What's the goal of
this part of the software? What is the schema good for? Storage of data
used by pgagent? I think I missed a bit of history :).

Feel free to answer privately if you think this is not useful to anybody
other than me.

Cheers,
Raphaël

Re: CVS Commit by dpage: Use schema 'pgadmin' as

From
Andreas Pflug
Date:
Raphaël Enrici wrote:
> cvs@developer.pgadmin.org wrote:
> may I ask for a short explanation concerning pgagent? What's the goal of
> this part of the software?

pgAgent is a daemon/service for scheduling data centric tasks. It's a
pgsql based replacement for cron/at/whatever, capable of executing sql
directly (e.g. cleanup some intermediate tables every night, or some
OLAP things), as well as calling shell scripts. All configuration and
logging is stored in the pgadmin schema.

pgAgent is supposed to have an easy to use gui (guess which...). As long
as no external scripts are executed, you shouldn't notice on which
platform pgsql/pgAgent is running on.

Regards,
Andreas

Re: CVS Commit by dpage: Use schema 'pgadmin' as PostgreSQL makes it

From
"Dave Page"
Date:


-----Original Message-----
From: Raphaël Enrici [mailto:blacknoz@club-internet.fr]
Sent: Sun 2/27/2005 10:01 AM
To: Dave Page
Cc: pgadmin-hackers@postgresql.org
Subject: Re: [pgadmin-hackers] CVS Commit by dpage: Use schema 'pgadmin' as PostgreSQL makes it

> (thanks for the tip concerning wx2.5.4 DL, the links are up to date now
> on wxwidgets' site.)

np.

> may I ask for a short explanation concerning pgagent? What's the goal of
> this part of the software? What is the schema good for? Storage of data
> used by pgagent? I think I missed a bit of history :).

pgAgent is a maintenance scheduling service/daemon. Andreas wrote most of it some time ago, but then got sidetracked.
I'm,err, re-focussing my activities at the moment, and pgAgent seemed like a good way to get back into C++ (I've been
doingC# and PHP mainly for the last year or so). 

Basically, pgAgent is a bit like the SQL Server Agent in SQL. You can create multi-step jobs (each step is a SQL
script,later shell scripts as well), and attach them to a schedule. The service/daemon then runs the steps sequentially
atthe appropriate time. 

Regards, Dave