Re: PgAgent does not works

From: Dave Page <dpage(at)postgresql(dot)org>
To: Vishal Arora <aroravishal22(at)hotmail(dot)com>, pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: PgAgent does not works
Date: 2007-06-25 11:46:33
Message-ID: 467FAB19.8000008@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Vishal Arora wrote:
> Hi
>
> I am sending the event file and dump once again. Sorry for trouble.

OK, that looks a little more like I'd expect.

So, the event log contains a of messages like:

Couldn't create connection: fe_sendauth: no password supplied.

(to get rid of the garbage before that, register pgaevent.dll using
regsvr32).

So you need to specify the password - see the bottom section of
http://www.pgadmin.org/docs/1.6/pgagent-install.html which discusses the
database password.

The database dump does also specify a schedule now - from an eyeball of
the arrays it looks like it's setup to run at 16:40 every Monday which
ties up with the job record which has a next runtime value of 2007-06-25
16:40:00+05:30.

Regards, Dave.

Browse pgadmin-support by date

  From Date Subject
Next Message Christophe Chauvet 2007-06-25 12:01:47 Re: PgAgent fail to connect on Windows startup
Previous Message Dave Page 2007-06-25 11:07:03 Re: PgAgent does not works