Re: Vacuum - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Vacuum
Date
Msg-id web-529312@davinci.ethosmedia.com
Whole thread Raw
In response to Vacuum  (Brian Avis <brian.avis@searhc.org>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Brian Avis
Date:
Subject: Vacuum
Next
From: "Fernando M. Maresca"
Date:
Subject: Import DB from DOS- dbase4