Re: Posgres 9.1.4

On 07/06/2012 05:14 PM, Vision Software Solutions wrote:
> Dear sir
> We are using postgres 9.1.4 as our database to all software
> development project. When we try to install on the windows 2000
> advance server we are getting an error during the installation as
> "Unknown Error executing pre installation actions"

As Dave Page notes, installing the latest PostgreSQL on an OS that isn't
supported by the PostgreSQL installer or even by Microsoft probably
won't work.

If you really must, you /might/ be able to use PostgreSQL on Win2k by
downloading the .zip package. You would need to manually manage it
using pg_ctl, initdb, etc or manually add a service using win2k
commands. I will not help you with this. Win2k is an ancient platform
that Microsoft dropped support for in 2010 (!!) and is not supported by
the EnterpriseDB-packaged installer.

Note that the .zip package of PostgreSQL /will not/ install any ODBC
drivers, etc, for you, so you'd need to sort those out separately.

A slightly saner way is to install a modern PostgreSQL on a modern
operating system and use it over the network from your fossil win2k box.
To do this may need to update the ODBC driver on your win2k box. You
/might/ be able to get the MSI installer to work (
http://www.postgresql.org/ftp/odbc/versions/msi/) but more likely you'll
have to hand-install it using the zip-and-dll package (
http://www.postgresql.org/ftp/odbc/versions/dll/) . Again, I will not
help you with this.

If you want help with this task you will probably need to contract paid
support from one of the companies that offers help with PostgreSQL. See:
http://www.postgresql.org/support/professional_support/

Seriously, MS hasn't supported win2k since July 2010
(http://support.microsoft.com/gp/lifean35) . For a longer term solution,
start here: http://support.microsoft.com/ph/1131 .

--
Craig Ringer