pgagent and pg_service.conf - Mailing list pgadmin-support

From Dirk-Jan Faber
Subject pgagent and pg_service.conf
Date
Msg-id CAOeEbjPc_oMZ-YdZUz+GL-dynCqFwiRViAOz4+vOWMFx8Zz1FQ@mail.gmail.com
Whole thread Raw
Responses Re: pgagent and pg_service.conf
List pgadmin-support
Hello,

I am just starting with pgagent. First thing I noticed was that it does not work with pg_service.conf. The installation documentation on http://www.pgadmin.org/docs/dev/pgagent-install.html refers to http://www.postgresql.org/docs/current/static/libpq.html#libpq-connect for more information on the connection string. 
That gave me the impression that the library that handles the connection string is shared between postgresql and pgagent.
So my question is wether or not the use of pg_service.conf is somewhere on the roadmap of pgagent and, if not, it can be put on the roadmap. This would save the trouble of having to maintain 2 files with the same information. 

$ pgagent_93 -f service=oaddev
ERROR: Primary connection string is not valid!
$ pgagent_93 -f hostaddr=pg-dev dbname=oad user=oaddev
ERROR: Could not find the table 'pgagent.pga_job'. Have you run pgagent.sql on this database?

(I know the last one gives an error right now, but at least it connects). 

I am using pgagent_93 on rhel6 (from http://yum.postgresql.org/9.3/redhat/rhel-6.6-x86_64/):
$ rpm -qf $(which pgagent_93)
pgagent_93-3.4.0-1.rhel6.x86_64

A --version option for pgagent might also be a nice addition. 

Best regards,
  Dirk-Jan Faber
  

pgadmin-support by date:

Previous
From: Julien Picalausa
Date:
Subject: Bug report: pgAdmin on Windows does not support password-protected private key
Next
From: hushthatbush@hushmail.com
Date:
Subject: When is 1.20 coming?