Thread: Posgres 9.1.4

Posgres 9.1.4

From
Vision Software Solutions
Date:
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"
 
Service pack 4 has been already setup on the above server.
 
Can you please advice on this
 
Regards
Wimal Prasanna
CEO
Vision software Solutions
 

Re: Posgres 9.1.4

From
Dave Page
Date:
Hi

On Fri, Jul 6, 2012 at 10:14 AM, Vision Software Solutions
<visionsw@sltnet.lk> 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"
>
> Service pack 4 has been already setup on the above server.

This is a pgAdmin support list, not PostgreSQL, but I can tell you
that Windows 2000 is not a supported platform for the PostgreSQL
installers. It's nearly 13 years old now, and has been superseded by 4
later versions at this point, soon to be 5!

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


Re: Posgres 9.1.4

From
Craig Ringer
Date:
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