good support doc here: http://www.pgadmin.org/docs/1. 8/pgagent-install.html
- add pgpass.conf to C:\Users\postgres\AppData\
Roaming\postgresql - should be localhost:5432:*:postgres:PASSWORD
- (note, this is not under the default user, it's the "postgres" user on your system)
- may also need the following in C:\Program Files (x86)\PostgreSQL\9.0\data\pg_hba.conf (but don't think so)
- local all all trust
- host all all XXX.XXX.XXX.XXX/32 trust
- reload configuration *running as admin*
- install pgAgent via application/stackbuilder (*run as admin*)
- make your steps ignore error, for some reason they error even if they complete successfully and stall subsequent steps
No comments:
Post a Comment