pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedupgrading to 7.4.2
5+ messages / 4 participants
[nested] [flat]
* upgrading to 7.4.2
@ 2004-03-23 10:55 Raul Secan <raul@zerosoft.ro>
2004-03-23 15:50 ` Re: upgrading to 7.4.2 Bruno Wolff III <bruno@wolff.to>
0 siblings, 1 reply; 5+ messages in thread
From: Raul Secan @ 2004-03-23 10:55 UTC (permalink / raw)
To: pgsql-php@postgresql.org
Hello, can anyone tell me the exact steps to upgrading from 7.4.1 to 7.4.2.
I didn't upgrade PostgreSQL until now, but I need to do that now, so I don't want to brake something.
Thanks, Raul Secan.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: upgrading to 7.4.2
2004-03-23 10:55 upgrading to 7.4.2 Raul Secan <raul@zerosoft.ro>
@ 2004-03-23 15:50 ` Bruno Wolff III <bruno@wolff.to>
2004-03-24 17:26 ` Re: [PHP] upgrading to 7.4.2 Bruno Wolff III <bruno@wolff.to>
0 siblings, 1 reply; 5+ messages in thread
From: Bruno Wolff III @ 2004-03-23 15:50 UTC (permalink / raw)
To: Raul Secan <raul@zerosoft.ro>; +Cc: pgsql-php@postgresql.org
On Tue, Mar 23, 2004 at 12:55:39 +0200,
Raul Secan <raul@zerosoft.ro> wrote:
> Hello, can anyone tell me the exact steps to upgrading from 7.4.1 to 7.4.2.
> I didn't upgrade PostgreSQL until now, but I need to do that now, so I don't want to brake something.
Pretty much you just need to shutdown the database before installing the
new binaries. You don't have to do a dump and restore. However, you want
to read the 7.4.2 release notes as a dump, initdb and restore may be the
easiest way for you to fix one of the problems fixed in 7.4.2.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [PHP] upgrading to 7.4.2
2004-03-23 10:55 upgrading to 7.4.2 Raul Secan <raul@zerosoft.ro>
2004-03-23 15:50 ` Re: upgrading to 7.4.2 Bruno Wolff III <bruno@wolff.to>
@ 2004-03-24 17:26 ` Bruno Wolff III <bruno@wolff.to>
0 siblings, 0 replies; 5+ messages in thread
From: Bruno Wolff III @ 2004-03-24 17:26 UTC (permalink / raw)
To: Raul Secan <raul@zerosoft.ro>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [PHP] upgrading to 7.4.2
@ 2004-03-24 17:44 Goulet, Dick <DGoulet@vicr.com>
2004-03-24 21:09 ` Re: [PHP] upgrading to 7.4.2 Christopher Browne <cbbrowne@acm.org>
0 siblings, 1 reply; 5+ messages in thread
From: Goulet, Dick @ 2004-03-24 17:44 UTC (permalink / raw)
To: Bruno Wolff III <bruno@wolff.to>; Raul Secan <raul@zerosoft.ro>; +Cc: pgsql-admin
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".
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [PHP] upgrading to 7.4.2
2004-03-24 17:44 Re: [PHP] upgrading to 7.4.2 Goulet, Dick <DGoulet@vicr.com>
@ 2004-03-24 21:09 ` Christopher Browne <cbbrowne@acm.org>
0 siblings, 0 replies; 5+ messages in thread
From: Christopher Browne @ 2004-03-24 21:09 UTC (permalink / raw)
To: pgsql-admin
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/;
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2004-03-24 21:09 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-23 10:55 upgrading to 7.4.2 Raul Secan <raul@zerosoft.ro>
2004-03-23 15:50 ` Bruno Wolff III <bruno@wolff.to>
2004-03-24 17:26 ` Bruno Wolff III <bruno@wolff.to>
2004-03-24 17:44 Re: [PHP] upgrading to 7.4.2 Goulet, Dick <DGoulet@vicr.com>
2004-03-24 21:09 ` Christopher Browne <cbbrowne@acm.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox