Обсуждение: Use Jobs
Hi people, Where can I find Job contrib and how to install jobs on postgres? Thanks for your help Alexander
On Tue, Nov 07, 2006 at 03:34:36PM -0200, Alexander Burbello wrote: > Where can I find Job contrib and how to install jobs on postgres? Right now the job agent that comes with pgAdminIII is your only option, though I'm hoping to get started again on the pgjobs project on pgFoundry. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
Jim - is there a component that needs to be installed on the database server with Postgres that PGAdmin communicates with please, or is only PGAdmin required?
Adrian
On 11/8/06, Jim C. Nasby <jim@nasby.net> wrote:
On Tue, Nov 07, 2006 at 03:34:36PM -0200, Alexander Burbello wrote:
> Where can I find Job contrib and how to install jobs on postgres?
Right now the job agent that comes with pgAdminIII is your only option,
though I'm hoping to get started again on the pgjobs project on
pgFoundry.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
On Wed, Nov 08, 2006 at 09:29:28PM +1300, adey wrote: > Jim - is there a component that needs to be installed on the database server > with Postgres that PGAdmin communicates with please, or is only PGAdmin > required? I know there's a server-side set of components for pgAdmin, but I don't know if the job agent needs them or not. BTW, my main motivation behind pgJob is to have something that has no external dependencies, so that you can just install it in any database. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
THanks Jim.
I've tried to get Jobs working, but have not been successful so far. I have some instructions, but they're sketchy at best, and my Unix skills are not strong, so I don't know what is required both in PGAdmin and in Postgres to get it working, or in what order, etc.
On 11/9/06, Jim C. Nasby <jim@nasby.net> wrote:
On Wed, Nov 08, 2006 at 09:29:28PM +1300, adey wrote:
> Jim - is there a component that needs to be installed on the database server
> with Postgres that PGAdmin communicates with please, or is only PGAdmin
> required?
I know there's a server-side set of components for pgAdmin, but I don't
know if the job agent needs them or not.
BTW, my main motivation behind pgJob is to have something that has no
external dependencies, so that you can just install it in any database.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
Sorry, but now I am in a doubt!! pgAdmin isn't a tool??? How can I install the feature Jobs and how can I schedule some procedure? Jim C. Nasby escreveu: >On Wed, Nov 08, 2006 at 09:29:28PM +1300, adey wrote: > > >>Jim - is there a component that needs to be installed on the database server >>with Postgres that PGAdmin communicates with please, or is only PGAdmin >>required? >> >> > >I know there's a server-side set of components for pgAdmin, but I don't >know if the job agent needs them or not. > >BTW, my main motivation behind pgJob is to have something that has no >external dependencies, so that you can just install it in any database. > >
Right now the only job scheduling utility for PostgreSQL is the job agent that was written by the pgAdmin folks. Or of course you could use your OS's built-in scheduling. On Fri, Nov 10, 2006 at 04:57:42PM -0200, Alexander Burbello wrote: > Sorry, but now I am in a doubt!! > > pgAdmin isn't a tool??? > How can I install the feature Jobs and how can I schedule some procedure? > > Jim C. Nasby escreveu: > > >On Wed, Nov 08, 2006 at 09:29:28PM +1300, adey wrote: > > > > > >>Jim - is there a component that needs to be installed on the database > >>server > >>with Postgres that PGAdmin communicates with please, or is only PGAdmin > >>required? > >> > >> > > > >I know there's a server-side set of components for pgAdmin, but I don't > >know if the job agent needs them or not. > > > >BTW, my main motivation behind pgJob is to have something that has no > >external dependencies, so that you can just install it in any database. > > > > > -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
Where can I find instructions to get it working please Jim?
I have Postgres and PGAdmin installed but I've not been able to get it working.
On 11/14/06, Jim C. Nasby <jim@nasby.net> wrote:
Right now the only job scheduling utility for PostgreSQL is the job
agent that was written by the pgAdmin folks. Or of course you could use
your OS's built-in scheduling.
On Fri, Nov 10, 2006 at 04:57:42PM -0200, Alexander Burbello wrote:
> Sorry, but now I am in a doubt!!
>
> pgAdmin isn't a tool???
> How can I install the feature Jobs and how can I schedule some procedure?
>
> Jim C. Nasby escreveu:
>
> >On Wed, Nov 08, 2006 at 09:29:28PM +1300, adey wrote:
> >
> >
> >>Jim - is there a component that needs to be installed on the database
> >>server
> >>with Postgres that PGAdmin communicates with please, or is only PGAdmin
> >>required?
> >>
> >>
> >
> >I know there's a server-side set of components for pgAdmin, but I don't
> >know if the job agent needs them or not.
> >
> >BTW, my main motivation behind pgJob is to have something that has no
> >external dependencies, so that you can just install it in any database.
> >
> >
>
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
I would try here: http://www.pgadmin.org/docs/1.4/pgagent.html On Tue, 14 Nov 2006, adey wrote: > Where can I find instructions to get it working please Jim? > I have Postgres and PGAdmin installed but I've not been able to get it > working. > > > On 11/14/06, Jim C. Nasby <jim@nasby.net> wrote: >> >> Right now the only job scheduling utility for PostgreSQL is the job >> agent that was written by the pgAdmin folks. Or of course you could use >> your OS's built-in scheduling. >> >> On Fri, Nov 10, 2006 at 04:57:42PM -0200, Alexander Burbello wrote: >> > Sorry, but now I am in a doubt!! >> > >> > pgAdmin isn't a tool??? >> > How can I install the feature Jobs and how can I schedule some >> procedure? >> > -- Jeff Frost, Owner <jeff@frostconsultingllc.com> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954
Please do not remove the list address from the Cc list, otherwise people who might be able to help you with this won't know to respond. In this case, that's important, because I don't use the pgadmin3 pgagent, and so can't help you any further. I'd suggest you look here for support though: http://www.pgadmin.org/support/ Looks like they have a FAQ and a support mailing list. Good luck! On Tue, 14 Nov 2006, adey wrote: > Thanks very much Jeff. > I'm sorry, I'm not very strong on Unix and will need to give my sysadmin > some instructions. > Is the daemon downloadable separately, from where, and can it be installed > separately "on top" of Postgres please? > > > On 11/14/06, Jeff Frost <jeff@frostconsultingllc.com> wrote: >> >> I would try here: http://www.pgadmin.org/docs/1.4/pgagent.html >> >> On Tue, 14 Nov 2006, adey wrote: >> >> > Where can I find instructions to get it working please Jim? >> > I have Postgres and PGAdmin installed but I've not been able to get it >> > working. >> > >> > >> > On 11/14/06, Jim C. Nasby <jim@nasby.net> wrote: >> >> >> >> Right now the only job scheduling utility for PostgreSQL is the job >> >> agent that was written by the pgAdmin folks. Or of course you could use >> >> your OS's built-in scheduling. >> >> >> >> On Fri, Nov 10, 2006 at 04:57:42PM -0200, Alexander Burbello wrote: >> >> > Sorry, but now I am in a doubt!! >> >> > >> >> > pgAdmin isn't a tool??? >> >> > How can I install the feature Jobs and how can I schedule some >> >> procedure? >> >> > >> >> -- >> Jeff Frost, Owner <jeff@frostconsultingllc.com> >> Frost Consulting, LLC http://www.frostconsultingllc.com/ >> Phone: 650-780-7908 FAX: 650-649-1954 >> > -- Jeff Frost, Owner <jeff@frostconsultingllc.com> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954