Re: pgagent and pg_service.conf

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