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