Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 0 down vote favorite

I've done some installs of PostgreSQL 9.0 64 bit on Windows Server 2008 R2 Standard.

When I connect to these instances, PGAdmin complains of the following:

The server lacks instrumentation Functions.

Apparently one is supposed to use the "official" pgInstaller program to install contrib modules in Windows PostgreSQL installs, including the server instrumentation.

However, the pgInstaller is only being maintained up to the PG9.0 RC, not the latest 9.0.1 version.

Given that, how do I get non-default contrib modules installed?

share|improve this question

1 Answer

up vote 1 down vote accepted

Uh, where did you get the idea that it's only maintained up until 9.0 RC? It's most definitely available for 9.0.1. Go to http://www.postgresql.org/download/windows, and you'll find it.

That said, installation of contrib modules is covered in the documentation at http://www.postgresql.org/docs/9.0/static/contrib.html. If you're building with mingw, that should just work. If you're building with msvc, then skip the build steps - they are always built on msvc - and just do the install/load step.

share|improve this answer
On the link you've provided, it states "pgInstaller is a Windows Installer package that offers advanced configuration options. pgInstaller packages are only being maintained for PostgreSQL 8.2 and 8.3.". So it's not even supported up to 9.0RC. – Scott Herbert Oct 20 '10 at 1:48
Hi Magnus, as far as I can tell this is where I'd expect to find the pgInstaller for 9.0.1 for Windows. postgresql.org/ftp/binary/v9.0.1 Can you please point out where I'm going wrong? – Scott Herbert Oct 21 '10 at 3:38
Go to the download page, as suggested. Click the link for "Download the one click installer". Follow the instructions. pgInstaller was replaced with the on-click-installers in 8.4. AFAIK they include all the contrib modules and then some. – Magnus Hagander Oct 22 '10 at 23:58
Thanks Magnus. My problem was that in most documentation for adding contrib modules in windows installs, the pgInstaller is mentioned as the way to get it done. It's not clear that the contribs are all included in the one-click installer, and that they're easily installed by running the scripts in the share folder. – Scott Herbert Oct 25 '10 at 4:09
a postscript: my reason for asking this question was that when I opened the server status app, it would say that log files weren't available. The way to fix this problem is to run PostgreSQL\9.0\share\contrib\adminpack.sql on the postgres database. – Scott Herbert Jan 15 '11 at 0:35

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.