Here are the steps which some one can use to configure the pgAgent. These steps are tested on my machine:

1. Login to system as test_user:

Please create a pgpass.conf file in test_user %APPDATA%\postgresql directory:

Entry for pgpass.conf should be as given below:

hostname:port:database:username:password

2. Connect to database as given below:

C:\”Program Files”\PostgresPlus\8.4\bin\psql.exe -U postgres

(Above command will also verify that pgpass.conf is used by the psql command or not)
3. After connecting to database, create plpgsql language as given below:

CREATE LANGUAGE plpgsql;

4. Now, run the pgagent.sql file.

5. Create pgAgent service, as given below:

pgagent.exe INSTALL pgAgent -u test_user -p test hostaddr=<host> dbname=<dbname> user=<username>

3. Start the created service using following command:

net start pgAgent

4. While Creating job, Please keep the output of following command in “Host Agent” field of “pgAgent Job” window:

select jagstation from pgagent.pga_jobagent;

4 Comments

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s