On Fri, Feb 20, 2009 at 3:33 PM, Ignacio Rojas <irc@dbcomputers.com.py> wrote:
> Hi all!
> My current pgAdmin III version is 1.8.4 installed on Ubuntu 8.10 Intrepid
> Ibex on a 64bit machine. I'm trying to use the pgAgent.
> I did the following step to try to configure it.
>
> 1) create a database from the command line
>
> $ createdb -U ignacio test
>
> 2) create plpgsql language
>
> $ createlang -U ignacio plpgsql dbname
>
> 3) open pgadmin, open localhost server connect to dbname and run the script
> locate on /usr/share/pgadmin3/pgagent.sql
>
> 4) i run pgagent hostaddr=locahost dbname=test user=ignacio
>
> 5) Hit refresh button
>
> And nothing... Whats wrong, any ideas? Tks...
I'm guessing you missed the part of the docs that said to run the
pgagent.sql script in the postgres database :-)
http://www.pgadmin.org/docs/1.8/pgagent-install.html
That should also be the database that your have pgAgent connect to,
and the one that pgAdmin initially connects to (which is the case by
default - check the Maintenance Database option on the Server
dialogue).
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com