X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 00796D1B4DE for ; Wed, 11 Feb 2004 00:36:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 71733-03 for ; Tue, 10 Feb 2004 20:36:52 -0400 (AST) Received: from diver.highboard.com (ns5.highboard.com [207.44.244.101]) by svr1.postgresql.org (Postfix) with ESMTP id 27BA9D1B4BE for ; Tue, 10 Feb 2004 20:36:49 -0400 (AST) Received: from roc-66-67-208-52.rochester.rr.com ([66.67.208.52] helo=swimmer) by diver.highboard.com with asmtp (Exim 4.24) id 1AqiNr-0006Aj-Qp; Tue, 10 Feb 2004 19:37:43 -0500 Reply-To: From: "Jeremy Smith" To: "scott.marlowe" Cc: Subject: Re: Upgrading from 7.2 to 7.4.1 on Redhat 7 Date: Tue, 10 Feb 2004 19:37:25 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal In-Reply-To: X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - diver.highboard.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - highboard.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/149 X-Sequence-Number: 12323 I actually had to install version 7.4.0 as there weren't any RPMs for 7.4.1 on Redhat 7.3. I am setting up some tables using phpPGadmin right now, and there is a link for "vacuum" so maybe that's it.. Jeremy -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of scott.marlowe Sent: Tuesday, February 10, 2004 7:15 PM To: Jeremy Smith Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Upgrading from 7.2 to 7.4.1 on Redhat 7 You're welcome. Glad it all worked for you. If it's any consolation, that's probably the hardest stuff you'll have to deal with in postgresql. do the 7.4.1 rpms include the autovacuum daemon? If so, get it set up to run and you shouldn't have to worry too much about holding postgresql's hand, so to speak. On Tue, 10 Feb 2004, Jeremy Smith wrote: > Thanks so much Scott, > > I followed this tutorial (linking it in case anyone has a similar troubles > in the future) on installing the RPMs: > http://www.lyris.com/lm_help/7.8/installing_postgresql_usin.html and it > worked out great! > > Jeremy > > -----Original Message----- > From: scott.marlowe [mailto:scott.marlowe@ihs.com] > Sent: Tuesday, February 10, 2004 5:50 PM > To: Jeremy Smith > Subject: RE: [ADMIN] Upgrading from 7.2 to 7.4.1 on Redhat 7 > > > On Tue, 10 Feb 2004, Jeremy Smith wrote: > > > Hello, > > > > thank you for this link. But I wonder, do I need to do this if postgres > has > > never actually been used by any user of this server in the past? > > Oh, then just uninstall the RPMs, rm -Rf the > /var/lib/whereeverpostgresqlputsdata directory and install the new rpms > and you're gold. > > > > > ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend