pgAgent wan't start on Windows XP and PG 8.4.1

I REMOVED pgAgent service and reinstall with a command like your....

-....with this command...

C:\programmi\postgresql\8.4\pgagent3\pgagent.exe INSTALL host=localhost port=5432 dbname=postgres user=postgres

Now i have this situation....

I see the problem in your configuration.
Please remove the pgAgent service using the following command:

And, reinstall the pgAgent service using the following command:

This should solve your problem.

Ok Ashesh_V, today after work i try to do this instructions...

Very very thanks for interesting in my problem... i hope to solve it !

hear you later so....

..... i tryed but the problem was not solved....

it wan't start....

in the pgpass.conf i have to put pc admin user or postgres user ?
I tryed every combination....

but is correct the path of pgpass.conf that i posted some thread ago ?

In pgpass.conf, you need to put the postgres user.

This message was edited 1 time. Last update was at 7 Oct 2009 14:31:21

This is the content of pgpass.conf file

127.0.0.1:5432:*:postgres:password
localhost:5432:*:postgres:password

and is located in this directory

C:\Documents and Settings\Stefano\Dati applicazioni\postgresql

is right ?

but service wan't start.... i don't understand....

in the event viewer i can see this advice

Couldn't create the primary connection (attempt 1): fe_sendauth: authentication type 5 not supported

Couldn't create the primary connection (attempt 2): fe_sendauth: authentication type 5 not supported

Maybe some double file in other directory make this problem ? as a duplicated pgpass.conf file in another directory ?

This message was edited 2 times. Last update was at 7 Oct 2009 14:44:37

Only way now I can think of is we provide the password in the connection string..
(Becuase I do not have the physical access to your system

)

Please remove the service using this command:

And, reinstall the pgAgent service using the following command:

This should help.

This message was edited 1 time. Last update was at 7 Oct 2009 14:58:42

nothing.....same error message....

maybe the problem is i have pgagent executable for installation not in BIN directory ?
maybe it run only when some correct job are configured ?
maybe i have to use PC name and not localhost or 127.0.0.1 ?

There is something wrong here...

1. Remove the pgpass.conf and try to start server

if not,
2. I feel - your password of PostgreSQL is something else.

Let's change it to actual one (using pgAdminIII)

Connect to the server using pgAdminIII and open the SQL Editor of pgAdminIII.

Then use the following SQL to change the password of 'postgres' user.

Use this password to recreate the 'pgAgent' service again.

Remove that pgpass.conf

ok....

pgpass.conf removed, service deleted and reinstalled.....pgpass.conf removed again....but service wan't start...

Did you change the password of postgres user on database as suggested?

This message was edited 1 time. Last update was at 8 Oct 2009 09:29:56

sure....with this command

ALTER USER postgres PASSWORD 'newpassord'

i used the same password for be sure i use the correct pass installing the service... (but was already right)

I think i have some initial problem, because this error happen on 2 different pc .... maybe during installation of postgres i forgot something ??

Can you please again post the output of the following command?
(I ran out of ideas, but still want to give a one more go)

sc qc pgAgent

NOTE: Please mark the passwords with XXX

Ok...

thank you very very much for help me to resolve my difficult problem

NEWS !!

In my home PC no change happen...

in my notebook i reinstall postgresql from start...

i install pgagent with this command

<path of postgresql & pgagent>pgagent.exe INSTALL -u postgres -p <postgres user password> -l2 hostaddr=127.0.0.1 dbname=postgres user=postgres password <postgres user password>

This because of i could see in my notebook the postgresql service was on postgres user account....

PgAgent start !!!

Note....i have not launched the stack builder for download optional software....

In my home pc, the same command don't work

Note.... i could obtain an errore on libpq.dll installation if i launch stack builder ...it say the software was not for my processor....

Note 2 .... the postgreSQL service wan't start if associated on postgres user....