Differences in installing Postgres 8.3.8

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

 

 

 


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux