|
Home > Archive > PostgreSQL Administration > November 2006 > Use Jobs
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Alexander Burbello 2006-11-07, 7:18 pm |
| Hi people,
Where can I find Job contrib and how to install jobs on postgres?
Thanks for your help
Alexander
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
| |
| Jim C. Nasby 2006-11-08, 5:43 am |
| 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
| |
|
| 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:
>
> 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
>
| |
| Jim C. Nasby 2006-11-09, 5:32 am |
| 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)
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
| |
|
| 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:
> server
>
> 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)
>
| |
| Alexander Burbello 2006-11-10, 7:24 pm |
| 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:
>
>
>
>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.
>
>
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly
| |
| Jim C. Nasby 2006-11-13, 7:20 pm |
| 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:
>
>
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
| |
|
| 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:
> procedure?
> PGAdmin
>
> --
> Jim Nasby jim@nasby.net
> EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
>
| |
| Jeff Frost 2006-11-13, 7:20 pm |
| I would try here: http://www.pgadmin.org/docs/1.4/pgagent.html
On Tue, 14 Nov 2006, adey wrote:
[color=darkred]
> 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:
--
Jeff Frost, Owner < jeff@frostconsulting
llc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
| |
| Jeff Frost 2006-11-13, 7:20 pm |
| 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@frostconsulting
llc.com> wrote:
>
--
Jeff Frost, Owner < jeff@frostconsulting
llc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
|
|
|
|
|