pgAgent installation fails - LIBPQ.DLL is missing - PostgreSQL 9.0.2 x64 - 2008 Windows Server x64

From: Stane Mikolič <stane(dot)mikolic(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgAgent installation fails - LIBPQ.DLL is missing - PostgreSQL 9.0.2 x64 - 2008 Windows Server x64
Date: 2011-01-21 13:49:10
Message-ID: AANLkTinRQX5f9JyZTcMfHCvW3DS7mZCCbL4SQuCNyVZX@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hello,

I have a problem with installing pgAgent on my Windows server.

1. Installed PostgreSQL 9.0.2 without errors with one click installer
for windows "postgresql-9.0.2-1-windows_x64"

2. pgAdmin III successfully connects to postgres database with
password provided in instalation

3. script pqagent.sql executes without errors

4. script pqagent_update.sql executes with warning: [WARNING ] ALTER
TABLE pgagent.pga_jobstep ADD COLUMN jstconnstr text NOT NULL DEFAULT
'' CONSTRAINT pga_jobstep_connstr_check CHECK ((jstconnstr != '' AND
jstkind = 's' ) OR (jstconnstr = '' AND (jstkind = 'b' OR jstdbname !=
'')))
ERROR: column "jstconnstr" of relation "pga_jobstep" already exists

5. jobs node shows in pgAdmin explorer tree

6. But when I try to install pgAgent

C:\Program Files\pgAgent\pgAgent INSTALL pgAgent -u postgres -p
secret hostaddr=127.0.0.1 dbname=postgres user=postgres
password=secret

I get an error message saying:

The program can't start because LIBPQ.DLL is missing from your
computer. Try reinstalling the program to fix this problem.

I tried looking for the libpq.dll.
- libpq.dll is present in postgresql bin directory
- if i copy .dll file to pgAgent directory i get a different error...
something with 0000x001
- same error if I copy pgAgent to bin directory

I tried x32 instalation of postgresql 9.0.2 with all DB drivers from
Stack builder - I get the same

My instalation on os x 1.6.x works fine - i got it up and running in no time.

Am I missing something? What do you make of it? Any suggestions /
solutions are welcome.

Best regards. S

-- System --

Processor: Intel(R) Xeon(R) CPU E5420 @ 2.50GHz
Instaled Memory: 1GB
System type: 64 bit Operating System

-- Windows Edition --

Windows Server R 2 Enterprise

System updates: all updates installed

-- Database --

Installed (in this order)

- postgresql-9.0.2-1-windows_x64
in C:\Program Files\PostgreSQL\9.0

DB drivers installed from Stack Builder:
- C:\Program Files (x86)\PostgreSQL\pgJDBC
- C:\Program Files (x86)\PostgreSQL\Npgsql
- C:\Program Files (x86)\PostgreSQL\psqlODBC

pgagent.sql script - (tried instaling pgAgent - missing .dll error)

pgagent_upgrade.sql script - (tried instaling pgAgent - same missing .dll error)

when running pgagent_upgrade.sql script I get the following warning:

[WARNING ] ALTER TABLE pgagent.pga_jobstep ADD COLUMN jstconnstr text
NOT NULL DEFAULT '' CONSTRAINT pga_jobstep_connstr_check CHECK
((jstconnstr != '' AND jstkind = 's' ) OR (jstconnstr = '' AND
(jstkind = 'b' OR jstdbname != '')))
ERROR: column "jstconnstr" of relation "pga_jobstep" already exists

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Piotr Czekalski 2011-01-21 20:58:56 Re: pgAgent installation fails - LIBPQ.DLL is missing - PostgreSQL 9.0.2 x64 - 2008 Windows Server x64
Previous Message Piotr Czekalski 2011-01-20 19:15:21 Debugger issue.