Vishal Arora wrote:

> There is nothing mentioned in the host agent field. I am sending the
> snapshots if you want to have a look at.
> - vishal

Whats your pgagent connection string?

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

>From: Dave Page <dpage@postgresql.org>
>To: Vishal Arora <aroravishal22@hotmail.com>
>CC: pgadmin-support@postgresql.org
>Subject: Re: [pgadmin-support] PgAgent does not works
>Date: Mon, 25 Jun 2007 10:50:03 +0100
>
>Vishal Arora wrote:
>
>>There is nothing mentioned in the host agent field. I am sending the
>>snapshots if you want to have a look at.
>>- vishal
>
>Whats your pgagent connection string?

pgAgent -u postgres -p XXXX hostaddr=127.0.0.1 dbname=postgres user=postgres

(where XXXX is replaced with the actual postgres password.) - Vishal
>
>Regards, Dave

__________________________________________________ _______________
Hotmail to go? Get your Hotmail, news, sports and much more!
http://mobile.msn.com


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Vishal Arora wrote:

> pgAgent -u postgres -p XXXX hostaddr=127.0.0.1 dbname=postgres
> user=postgres

Hmm, OK - can you please add -l 2 to that to increase the log output,
and send me a dump of that from eventviewer once it's run long enough to
have missed a job, along with a pg_dump of your pgagent schema from the
postgres database.

thanks, Dave

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Khan, Mahmood Ahram wrote:
> Still not working
>

Assuming thats an error you get when starting pgagent, then I think it's
fairly clear what the problem is from the log you posted:

Event Type: Failure Audit
Event Source: Security
Event Category: Logon/Logoff
Event ID: 529
Date: 6/25/2007
Time: 3:57:20 PM
User: NT AUTHORITY\SYSTEM
Computer: INBLR-KHANM2
Description:
Logon Failure:
Reason: Unknown user name or bad password
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
User Name: postgres
Domain: INBLR-KHANM2
Logon Type: 5
Logon Process: Advapi
Authentication Package: Negotiate
Workstation Name: INBLR-KHANM2

And am I safe to assume from the similarity of your computer hostnames
that you and Vishal are working together, or at least in the same company?

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq