pgagent and pg_service.conf

From: Dirk-Jan Faber <dfaber(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgagent and pg_service.conf
Date: 2014-12-16 10:17:10
Message-ID: CAOeEbjPc_oMZ-YdZUz+GL-dynCqFwiRViAOz4+vOWMFx8Zz1FQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message hushthatbush 2014-12-16 10:43:08 When is 1.20 coming?
Previous Message Julien Picalausa 2014-12-10 21:30:43 Bug report: pgAdmin on Windows does not support password-protected private key