Changes between Version 33 and Version 34 of sysadminPostgreSQLConfiguration


Ignore:
Timestamp:
Jun 29, 2009, 4:12:45 PM (13 years ago)
Author:
risard
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • sysadminPostgreSQLConfiguration

    v33 v34  
    144144{{{
    145145    su postgres
    146     pg_ctl start -D /data/postgresql/8.3/main -l /<path_to_log_file>/<my_logfile>
     146    /usr/lib/postgresql/8.3/bin/pg_ctl -D /data/postgresql/8.3/main -l /<path_to_log_file>/<my_logfile> #log file is optional
     147
    147148}}}
    148149
     
    211212
    212213{{{
     214    psql # note I don't use psql -d evergreen, you can't drop the db if you're using it
    213215    drop database evergreen;
    214216}}}     
     
    234236
    235237{{{
    236 createuser -P -s evergreen
     238    createuser -P -s evergreen
    237239}}}
    238240
     
    262264
    263265{{{
    264     VACUUM
    265     ANALYZE
     266    su postgres
     267    psql -d evergreen
     268    psql# VACUUM
     269    psql# ANALYZE
    266270}}}
    267271
     
    314318   
    315319    su postgres
    316     pg_ctl -D /data/postgresql/8.3/main -l /<path_to_log_file>/<my_logfile>
     320    /usr/lib/postgresql/8.3/bin/pg_ctl -D /data/postgresql/8.3/main -l /<path_to_log_file>/<my_logfile> #log file is optional
    317321
    318322}}}
     
    354358
    355359    su postgres
    356     VACUUM
    357     ANALYZE
     360    psql -d evergreen
     361    psql# VACUUM
     362    psql# ANALYZE
    358363}}}
    359364