pgAgent wan't start on Windows XP and PG 8.4.1

What was the exact command you use to install the pgAgent service (Please mark password with *****, whenever applicable)?

What is the output of "echo %USERNAME%" in command prompt?

This message was edited 2 times. Last update was at 16 Sep 2009 14:33:38

echo %username% return Stefano

-----for installa i used Stefano username, the PC administrator user and the password of Stefano

I found an advice in event viewer.....it say

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

P.S. thanks for your help....now i have to shut down , tomorrow i answer to you again

I hope to resolve this problem..... i have to put scheduler on my Agency where will run postgreSQL

nothing...it wan't run....

i tried to reinstall all postgresql but no change happened...

someone have idea for how to solve this problem ??

Please someone help me to resolve this problem, i cannot start pgAgent....i try everything in my capacity...

I wannot the problem is on one of my actions..... it don't run in 2 pc, so i think is difficult....

i put service in automatic mode and it wan't start...

what i could try ????

This message was edited 1 time. Last update was at 23 Sep 2009 01:06:17

You need to create pgpass.conf file in your %APPDATA%\postgresql directory. (APPDATA of Stefano user)
Please follow this link for more details.
http://www.postgresql.org/docs/8.4/interactive/libpq-pgpass.html

This message was edited 1 time. Last update was at 23 Sep 2009 09:49:12

Thank you Ashesh_v, as i wrote in some previous thread , i have already the pgpass.conf file in Stefano directory....

This is the contento of this file

localhost:5432:*:stefano:mypassword

i put this file (for try) also in superuser postgresql application data directory but is the same...

I would specify that the message i obtain trying to start pgagent service from service applet console is like this

"PgAgent service was started and then was stopped....some services use to do this if there are nothing to do...."

someone have an idea for help me ?

Have i to reinstall all ?

Ashesh_V where are you ???

Sorry for late reply.

How do you connect you the postgres server?
The username & password in the pgpass.conf file should not be your system user & system password.

If you've used one click installer to install the postgres than your super user should be 'postgres'.

Suppose, you use this command to connect to postgres server using psql.
psql -U postgres -p 5432 -h localhost postgres

Than, contents of the pgpass.conf should be:

This message was edited 1 time. Last update was at 29 Sep 2009 16:13:02

I'm confused now.... i try every configuration possible, so i have to wrong something...

i open the directory
C:\Documents and Settings\Stefano\Dati applicazioni\postgresql

(stefano is the PC administrator user)

and i edit the pgpass.conf file

i put something like this

localhost:5432:*:postgres:visual6
127.0.0.1:5432:*:postgres:visual6

I connect with pgAdmin III to postgresql with this user & password as superuser..

i try with ALL user & password i know for postgresql...

...i use PC administrator, Postgresql Superuser, normal postgresql user ecc.ecc....

i launch service from CMD with

NET START pgAgent

the message is ever the same....

I have no idea of my error....because it have to exist an error....

The error is the file i edited is not correct ?
have i to assign default user & password ?
have i to reinstall all ??

This message was edited 1 time. Last update was at 29 Sep 2009 16:11:27

I'm confused now.... i try every configuration possible, so i have to wrong something...

i open the directory
C:\Documents and Settings\Stefano\Dati applicazioni\postgresql

and i edit the pgpass.conf file

i put something like this

localhost:5432:*:postgres:mypassword
127.0.0.1:5432:*:postgres:mypassword

and try with ALL user & password i know for postgresql...

...i use PC administrator, Postgresql Superuser, normal postgresql user ecc.ecc....

i launch service from CMD with

NET START pgAgent

the message is ever the same....

I have no idea of my error....because it have to exist an error....

The error is the file i edited is not correct ?
have i to assign default user & password ?
have i to reinstall all ??

No, you do not need to install it from scratch.

Please give me the output of these command.

This will give us the idea about the configuration of pgAgent service.
It should give output similar to the following one:

In above output,
Forth line: BINARY_PATH_NAME Contains
* Full path of the pgAgent executable
* Service name next to RUN (command argument)
* Connection String (the whole string next to the service name), which includes your database user, database name (where pgagent schema presents), port & host on which database is running. NOTE: Here, You can give database password too using "password=xxx" string, But, It is not recommended because of security concerns.
Ninth Line: SERVICE_START_NAME contains:
* Name of the operating system user, using which you've installed pgAgent service.
NOTE: You need to create the pgpass.conf file for this user

Hope this helps.

This message was edited 1 time. Last update was at 30 Sep 2009 09:18:09

I upload a screenshot of the command sc qc pgAgent

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...