On Fri, Feb 20, 2009 at 3:33 PM, Ignacio Rojas <i...@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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support