Differences in installing Postgres 8.3.8

From: Kasia Tuszynska <ktuszynska(at)esri(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Differences in installing Postgres 8.3.8
Date: 2009-11-17 00:59:31
Message-ID: 232B5217AD58584C87019E8933556D11014F3BACCB@redmx2.esri.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello Postgres Gurus,
I have a feeling that I might be posting the following question to the wrong site but just in case I will ask it here first.

I am comparing different postgres installation packages for Postgres 8.3.8:
On windows: the msi vs. the one-click-installer
On linux: the rpms vs. the one-click-installer

To my surprise the different installers do not install the same options and additions to the basic Postgres server, I have not compared the availability of all of the options, as I am mostly interested in the contrib modules that install the:
- xml native postgres type - libxml lib
- guid native postgres type - uuid-ossp.sql

I found that:
On windows
-no matter what installation package I use libxml gets installed by default
-the uuid-ossp.sql is a check box with the msi, but not an option with the one-click-installer ( nor does it get put down by the one-click-installer by default, without having an option)
-if I had 8.3.0 installed on a machine with the msi and I executed the 8.3.8 msi than there is a upgrade.bat I can run for an inplace upgrade, if however I try to use the 8.3.8 one-click-installer I can not do an inplace upgrade and I get an error message that says: The existing data directory (Date/time setting: floating-point numbers) is not compatible with this server Date/time setting: 64-bit integers). Which means that I need to uninstall and reinstall.

On Linux
-rpms do not install the xml type by default
-one-click installer does install the xml type by default
-uuid-ossp.sql does not get installed by either one of them and executing the sql file is looking of a $libdir parameter which I would change if I knew what it was set to in a working Postgres install

Question1:
Is it expected behavior that different installers give a different outcome?

Question2 ( much more important than Q1):
Is it possible to get an rpm build for linux that will behave like the msi installer on windows? I am looking for a consistent way that we could put down Postgres on different platforms and know that the installation will be the same. The msi installer installs the xml type by default and makes uuid-ossp available, it would be great if the rpms could do the same or put down both options by default.

Thanks,
Sincerely,
Kasia

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2009-11-17 04:14:29 Re: Differences in installing Postgres 8.3.8
Previous Message Tom Lane 2009-11-16 18:42:21 Re: Failed to restore/recreate database (one more piece of info)