Обсуждение: Vacuum

Sorry if this is a double post, I can't tell if it made it the first
time so will try again.

Right now I am running vacuum like this from a script.

/usr/local/pgsql/bin/psql -c vacuum $database

 From the reading I have done I am led to believe that running vacuum
analyze is the better way to go. But if I change to line to this.

/usr/local/pgsql/bin/psql -c vacuum analyze $database

I get these errors.

psql: FATAL 1:  Database "analyze" does not exist in the system catalog

So how do I do a vacuum analyze?

Thank you for you assistance.  :)


--
Brian Avis
SEARHC Medical Clinic
Juneau, AK 99801
(907) 463-4049
cd /pub
more beer

Brian,

>  From the reading I have done I am led to believe that running vacuum
> analyze is the better way to go. But if I change to line to this.
>
> /usr/local/pgsql/bin/psql -c vacuum analyze $database

Use quotes:

/usr/local/pgsql/bin/psql -c "vacuum analyze" $database

-Josh


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco