pgAgent wan't start on Windows XP and PG 8.4.1

HEllo,

i'm installing pgagent on windows xp with postgreSQL 8.4.1 version...

The service is listed on service list but wan't start....

trying to start by command NET START pgAgent return no error but it say the service cannot be started...

Someone could help me ?

This message was edited 1 time. Last update was at 16 Sep 2009 10:22:10

Hi,

How are you trying to install the pgAgent?
Want to know, from where did you get the binaries or you build it your self, before answering your question.

Hi, thanks for your reply

hi install in this way....

from command prompt as administrator user

"C:\programmi\postgresql\8.4\pgAgent3\pgagent.exe" INSTALL pgAgent hostaddr=localhost -u Pcuser -p password dbname=postgres user=postgres

Instead use this command to install the pgAgent:
"C:\programmi\postgresql\8.4\pgAgent3\pgagent.exe" INSTALL pgAgent hostaddr=localhost -l2 -u Pcuser -p password dbname=postgres user=postgres

Make sure, you have installed pgagent schema in the database 'postgres'.
If not, run pgAgent.sql against the database 'postgres'.

just run pgagent.sql file, i have a catalogue called pgagent in postgres server and job icon activated...

i tried adding "l2" option for install (after removed) but the service not run

Now, check the windows Event manager, and check what error you're getting?
You should be able to find the event manager in Administrator tools

i found this error

Stopping pgAgent: Couldn't establish the primary connection with the database server.

You need to create a file named "pgpass.conf" in %APPDATA%\postgresql directory.
Please follow this link for details.
http://www.postgresql.org/docs/current/static/libpq-pgpass.html

This message was edited 1 time. Last update was at 16 Sep 2009 13:33:21

Ok....i found the file and was empty....

i added i line like this

localhost:5432:postgres:postgres:password

But have i to set for postgres or for DB which need job scheduler ?
Can i add more lines ?

I have a postgres server, the default server on PgAdmin, where i have my DB where i would to set job scheduler...... which line have i to add ?

Whith this line it wan't run....

You can use the same username (postgres) and password for all the database as it is super user in your case.
Please use this line in your file.
localhost:5432:*:postgres:password

You can add more line of similar pattern patterns.

i modify the string.....

trying to start pgagent with command NET START pgAgent but don't start....same errore reported in event viewer....

i can say i have a new user of PC, called postgres....but i'm running with another user with admin properties...

But, postgres is your super user for your database.
Don't get confused by operation system administrator and database super user.

BTW: Can you please send us the contents of the %APPDATA%\postgresql\pgpass.conf file?

oh yes...

localhost:5432:*:postgres:visual6

i used user and password for postgres connection wich i use for connect with pgadmin

What is the value of the pcUser in your command?
Is it the same as the current logged in user?

This message was edited 1 time. Last update was at 16 Sep 2009 14:24:36

no is different.....

i use
Username = postgres
Password = password

for connect to postgresql with pgAdmin

and

username = Stefano
password = password

for use the system administrator

in the command used for installa pgagent i used a PC admin account , Stefano

i try first and second account for pgpass.conf but pgagent won't run

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