From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Jeremy Smith <jer(at)highboard(dot)com> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Upgrading from 7.2 to 7.4.1 on Redhat 7 |
Date: | 2004-02-11 00:51:20 |
Message-ID: | Pine.LNX.4.33.0402101749430.30219-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Log in as root, then "su - postgres" and type in "pg_autovacuum --help"
and see if you get a response from that. If so, the the autovacuum
daemon is there, and all you have to do to get it running it its basic
format is to run it with 'pg_autovacuum -D'.
On Tue, 10 Feb 2004, Jeremy Smith wrote:
> 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(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of scott.marlowe
> Sent: Tuesday, February 10, 2004 7:15 PM
> To: Jeremy Smith
> Cc: pgsql-admin(at)postgresql(dot)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(dot)marlowe(at)ihs(dot)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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Creager | 2004-02-11 02:49:04 | Log query results? |
Previous Message | Jeremy Smith | 2004-02-11 00:37:25 | Re: Upgrading from 7.2 to 7.4.1 on Redhat 7 |