Differences in installing Postgres 8.3.8

--_000_232B5217AD58584C87019E8933556D11014F3BACCBredmx2esric om_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello Postgres Gurus,
I have a feeling that I might be posting the following question to the wron=
g 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 availabili=
ty 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 b=
y 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 howe=
ver I try to use the 8.3.8 one-click-installer I can not do an inplace upgr=
ade and I get an error message that says: The existing data directory (Date=
/time setting: floating-point numbers) is not compatible with this server D=
ate/time setting: 64-bit integers). Which means that I need to uninstall an=
d 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 t=
he sql file is looking of a $libdir parameter which I would change if I kne=
w 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 d=
own 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 dow=
n both options by default.

Thanks,
Sincerely,
Kasia

--_000_232B5217AD58584C87019E8933556D11014F3BACCBredmx2esric om_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:schemas-m=
icrosoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-com:office=
:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=3D"=
uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:schemas-microsof=
t-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schemas-microsoft-co=
m:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadshee=
t" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xmlns=
:odc=3D"urn:schemas-microsoft-com:office:odc" xmlns:oa=3D"urn:schemas-micro=
soft-com:office:activation" xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc=3D"http://m=
icrosoft.com/officenet/conferencing" xmlns:D=3D"DAV:" xmlns:Repl=3D"http://=
schemas.microsoft.com/repl/" xmlns:mt=3D"http://schemas.microsoft.com/share=
point/soap/meetings/" xmlns:x2=3D"http://schemas.microsoft.com/office/excel=
/2003/xml" xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" xmlns:ois=
=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir=3D"http://=
schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds=3D"http://www.w3=
..org/2000/09/xmldsig#" xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint=
/dsp" xmlns:udc=3D"http://schemas.microsoft.com/data/udc" xmlns:xsd=3D"http=
://www.w3.org/2001/XMLSchema" xmlns:sub=3D"http://schemas.microsoft.com/sha=
repoint/soap/2002/1/alerts/" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"=
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" xmlns:sps=3D"http://=
schemas.microsoft.com/sharepoint/soap/" xmlns:xsi=3D"http://www.w3.org/2001=
/XMLSchema-instance" xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/so=
ap" xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " xmlns:udc=
p2p=3D"http://schemas.microsoft.com/data/udc/parttopart" xmlns:st=3D"" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>

</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Hello Postgres Gurus,<o:p></o:p>

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.<o:p><=
/o:p>

<o:p> </o:p>

I am comparing different postgres installation packages =
for
Postgres 8.3.8:<o:p></o:p>

On windows: the msi vs. the one-click-installer <o:p></o=
:p>

On linux: the rpms vs. the one-click-installer<o:p></o:p=
>

<o:p> </o:p>

To my surprise the different installers do not install t=
he
same options and additions to the basic Postgres server, I have not compare=
d the
availability of all of the options, as I am mostly interested in the contri=
b modules
that install the: <o:p></o:p>

<![if !supportLists]><s=
pan
style=3D'mso-list:Ignore'>- =

<![endif]><s=
pan
style=3D'font-size:10.0pt;font-family:Arial'>xml native postgres type - lib=
xml
lib<o:p></o:p>

<![if !supportLists]><s=
pan
style=3D'mso-list:Ignore'>- =

<![endif]><s=
pan
style=3D'font-size:10.0pt;font-family:Arial'>guid native postgres type - uu=
id-ossp.sql<o:p></o:p>

<o:p> </o:p>

I found that:<o:p></o:p>

On windows <o:p></o:p>

-no matter what installation package I use libxml gets
installed by default<o:p></o:p>

-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)<o:p></o:p>=


-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 wit=
h
this server Date/time setting: 64-bit integers). Which means that I need to
uninstall and reinstall.<o:p></o:p>

<o:p> </o:p>

On Linux<o:p></o:p>

-rpms do not install the xml type by default<o:p></o:p><=
/span>

-one-click installer does install the xml type by defaul=
t<o:p></o:p>

-uuid-ossp.sql does not get installed by either one of t=
hem and
executing the sql file is looking of a $libdir parameter which I would chan=
ge
if I knew what it was set to in a working Postgres install<o:p></o:p></span=
>

<o:p> </o:p>

Question1:<o:p></o:p>

Is it expected behavior that different installers give a
different outcome? <o:p></o:p>

<o:p> </o:p>

Question2 ( much more important than Q1=
):<o:p></o:p>

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 k=
now
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 cou=
ld
do the same or put down both options by default.<o:p></o:p></=
b>

<o:p> </o:p>

Thanks,<o:p></o:p>

Sincerely,<o:p></o:p>

Kasia <o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

<o:p> </o:p>

</div>

</body>

</html>

--_000_232B5217AD58584C87019E8933556D11014F3BACCBredmx2esric om_--

Kasia Tuszynska [ Di, 17 November 2009 01:59 ] [ ID #2023076 ]

Re: Differences in installing Postgres 8.3.8

--=-2jtXm0DZGZCdtCZLU0xe
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, 2009-11-16 at 16:59 -0800, Kasia Tuszynska wrote:
>
> On Linux
> -rpms do not install the xml type by default

You need to install postgresql-contrib package.

Regards,
--
Devrim G=C3=9CND=C3=9CZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

--=-2jtXm0DZGZCdtCZLU0xe
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEABECAAYFAksCIyMACgkQtl86P3SPfQ6uogCgi7HD6L9wIeSDCfPzrHYr fSxX
dTMAn1YLDcImj/sSV819YiH9cwBWDRkP
=GS+6
-----END PGP SIGNATURE-----

--=-2jtXm0DZGZCdtCZLU0xe--

devrim [ Di, 17 November 2009 05:14 ] [ ID #2023077 ]

Re: Differences in installing Postgres 8.3.8

Le mardi 17 novembre 2009 =E0 01:59:31, Kasia Tuszynska a =E9crit :
> [...]
> Question1:
> Is it expected behavior that different installers give a different outcom=
e?
>

Yes.

> 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?

You'll have to build your own, and I'm not sure this is such a great idea. =
The
RPM packages are done in a way that they reuse other packages (libxml for=

example), and the one click installer ships all it needs. They have two
strictly different behaviors because they don't intend to achieve the same=

goals.

> 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.
>

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Guillaume Lelarge [ Di, 17 November 2009 18:29 ] [ ID #2023080 ]