Hi Mike,

As promised.
I think I broke the Da Vinci Code!

It seems you would have to use rpm -ivh instead of rpm -uvh
This would create extra entries which one could remove from the rpm
database. No need to remove totally per se, otherwise all the Ingres
installation will be gone with the wind.
So, for that use rpm -e --justdb old_rpm
I think it should be stated (see the second statement) , that should the
user decide to use rpm -uvh as opposed to rpm -ivh and rpm -e -justdb,
the user should use it in the following manner:
rpm -uvh -replacefiles -replacepkgs new_rpm

Hope this helps.


Cheers,
Armand

-----Original Message-----
From: info-ingres-admin@cariboulake.com
[mailto:info-ingres-admin@cariboulake.com] On Behalf Of Michael Leo
Sent: Thursday, March 24, 2005 5:31 PM
To: info-ingres@cariboulake.com
Cc: 'Marianne R. Shaieb'
Subject: RE: [Info-ingres] How to upgrade to the latest version of r3 on
Linux?

At 9:38 AM -0600 3/17/05, Armand Pirvu \(yahoo\) wrote:
I can give a hint on the second question Mikey.

rpm -Uvh foo-1.0-2.i386.rpm

So, make sure you have -Uvh in the scripts provided when you want to
upgrade. Should be OK I guess. You may have to fiddle with some stuff in
the install script, and that would be mainly RPMVERS='3.0.1-109'

Armand,

I found this in the documentation (missed it the first time):

----------------------------------------------------------------------
Due to a limitation in RPM, when upgrading from an earlier version of
Ingres 3.0.1 to a later version of Ingres, you should not install with
"rpm -Uvh new-package-list", but rather install with "rpm -ivh
new-package-list". This will create extra entries in the RPM database
that can be removed by running "rpm -e --justdb old-package-list".

If the newer version of Ingres is installed with "rpm -Uvh
new-package-list", it will delete the Ingres binaries and other
distributed files. The Ingres databases and other user files will be
left in place. You must run "rpm -Uvh --replacefiles --replacepkgs
new-package-list" to update the Ingres files. The Ingres installation
will then be properly updated.
----------------------------------------------------------------------

I find this rather, uh, cryptic. I understand the first sentence. I'm
not sure if I should execute the rpm command in the second sentence.

The second paragraph is odd. To me, it says "if you didn't follow
the proper instructions in the first place, do this", or am I missing
something?

Regardless, none of these options work. Every one complains about
failed dependencies.

Can someone point me to the upgrade procedure? Has anyone done it?

Cheers,

--
Michael Leo Java, J2EE, BEA WebLogic,
Caribou Lake LLC Oracle, Open Source, Ingres,
mleo@cariboulake.com Real Enterprise Applications

Climate is what we expect. Weather is what we get.
- Mark Twain