Re: correr pgagent sin instalar servicio en windows

Me autorespondo, la ayuda lo dice:
Service installation on Windows
pgAgent is able to self-install itself as a service on Windows systems. The
command line options available are similar to those on *nix systems, but include
an additional parameter to tell the service what to do:
Usage: pgAgent REMOVE <serviceName> pgAgent INSTALL <serviceName> [options] <connect-string> pgAgent DEBUG [options] <connect-string> options: -u <user or DOMAIN\user> -p <password> -d <displayname> -t <poll time interval in seconds (default 10)> -r <retry period after connection abort in seconds (>=10, default 30)> -l <logging verbosity (ERROR=0, WARNING=1, DEBUG=2, default 0)>
The service may be quite simply installed from the command line as follows
(adjusting the path as required):
"C:\Program Files\pgAdmin III\pgAgent" INSTALL pgAgent -u postgres -p secret hostaddr=127.0.0.1 dbname=postgres user=postgres
The service may then be started from the command line using net start
pgAgent, or from the Services control panel applet. Any logging
output or errors will be reported in the Application event log. The DEBUG mode
may be used to run pgAgent from a command prompt. When run this way, log
messages will output to the command window.

Entonces seria asi:

G:\postgresql\pgsql\bin>G:\postgresql\pgsql\bin\pgAgent DEBUG -l 0 hostaddr=localhost dbname=postgres user=postgres password=123
y listo, funciona el job funciona pectecto
y para cerrarlo un Control+C es suficiente

________________________________
De: Alejandro Carrillo <fasterzip(at)yahoo(dot)es>
Para: "pgsql-es-ayuda(at)postgresql(dot)org" <pgsql-es-ayuda(at)postgresql(dot)org>
Enviado: miércoles 5 de octubre de 2011 15:47
Asunto: [pgsql-es-ayuda] correr pgagent sin instalar servicio en windows

hola,

Necesito crear un bat en windows q me permite correr pgagent sin necesidad de instalar el servicio de windows. ¿Conocen el comando para ejecutar el pgadmin de esta forma?

Gracias