Postgres PgAgent

[Chris Hughes]

Postgres Pgagent 

Not working has anybody go any ideas of why not.

Does PGAdmin4 work ?, managed years ago to get PGAdmin3 working.

Pgagent is Installed on Windows 10.
done.

PgAdmin Installed.
done

CREATE EXTENSION pgagent; Into Postgres maintenance DB
done

 

CREATE LANGUAGE plpgsql;
done
 
Bat file created and runs manually
done
 
Path name have used double " marks as spaces this sometimes cause problems "
done
 
Activate RUN now
no go.
 
Checked Postgres running in "Systems"
 
Check PgAgent is not running,  the system" states the following when trying
to start manually 
" Some services stop automatically if they are not in use by other services
or programs"
 
Created Schedules did not put "End Date" in, as some tips from net say not
necessary.
 
Created Steps.
 
Checked out the pgpass.conf file in %appdata% reads as follows "
*:5432:postgres: 06021953aq "
 
Have got to do anything here:_

pgAgent can install itself as a service on Windows systems. The command line
options available are similar to those on Unix 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
(adjust the path as required):

 
 
Is there something I am missing.
 

 

Chris Hughes

 

Copious Data Pty Ltd (Trading as Atad Data)

3 Springwell Avenue

Springwood QLD 4127

Phone No:- 07 3208 6347

Mobile No:- 0409 263 349

Email:- ataddata at bigpond.net.au

Web Site:- http://ataddata.com.au