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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of scott.marlowe > Sent: Tuesday, February 10, 2004 7:15 PM > To: Jeremy Smith > Cc: [EMAIL PROTECTED] > 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:[EMAIL PROTECTED] > > 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 > > > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
