Обсуждение: Re: [PHP] upgrading to 7.4.2

Comparing a MySql upgrade to anything else is comparing apples to eggplants.  Their not even in the same group.  mySql
likesto leave their datafiles alone making all of their changes in the binaries.  Now while that is good from an
upgradestandpoint, what do you upgrade for?  New Features.  MySql doesn't like new features as it will "slow down the
database".

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Bruno Wolff III [mailto:bruno@wolff.to]
Sent: Wednesday, March 24, 2004 12:26 PM
To: Raul Secan
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] [PHP] upgrading to 7.4.2


I am copying this back to the admin list to keep the discussion where more
people can comment. (The admin list is more appropiate than the PHP
list where your initial questions were posted.)

On Wed, Mar 24, 2004 at 10:09:51 +0200,
  Raul Secan <raul@zerosoft.ro> wrote:
> What I mean is that this is the only posibility to upgrade Postgres, by
> deleting the old one and installing the new one?
>
> Isn't there an easy way to upgrade this database server (for example MySQL's
> upgrade is very easy to do: rpm -Uvh mysql.xxxxx.rpm)?

If you have rpms for 7.4.2 you can do the update that way. That just replaces
the binaries, it doesn't do anything to the data. That technique will
work as long as you are doing an upgrade between two minor releases of
the same major release. You have to do a dump first if you are changing
major release version. Also you should read the release notes for 7.4.2
as there are some special instructions in this case.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Quoth DGoulet@vicr.com ("Goulet, Dick"):
> Comparing a MySql upgrade to anything else is comparing apples to
> eggplants.  Their not even in the same group.  mySql likes to leave
> their datafiles alone making all of their changes in the binaries.
> Now while that is good from an upgrade standpoint, what do you
> upgrade for?  New Features.  MySql doesn't like new features as it
> will "slow down the database".

Oh, but that's not true anymore. MySQL(tm) is supposed to support
subqueries, stored procedures, triggers, and views Real Soon Now...
And remember, their reason for being is to provide "the world's most
popular open source database."  If popularity requires dressing up in
slower clothing, well, that's presumably going to happen...
--
let name="cbbrowne" and tld="acm.org" in String.concat "@" [name;tld];;
http://cbbrowne.com/info/nonrdbms.html
Rules of  the Evil Overlord  #228.  "If the  hero claims he  wishes to
confess  in public  or to  me  personally, I  will remind  him that  a
notarized deposition will serve just as well."
<http://www.eviloverlord.com/>