Changes between Version 33 and Version 34 of sysadminPostgreSQLConfiguration
- Timestamp:
- Jun 29, 2009, 4:12:45 PM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
sysadminPostgreSQLConfiguration
v33 v34 144 144 {{{ 145 145 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 147 148 }}} 148 149 … … 211 212 212 213 {{{ 214 psql # note I don't use psql -d evergreen, you can't drop the db if you're using it 213 215 drop database evergreen; 214 216 }}} … … 234 236 235 237 {{{ 236 createuser -P -s evergreen238 createuser -P -s evergreen 237 239 }}} 238 240 … … 262 264 263 265 {{{ 264 VACUUM 265 ANALYZE 266 su postgres 267 psql -d evergreen 268 psql# VACUUM 269 psql# ANALYZE 266 270 }}} 267 271 … … 314 318 315 319 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 317 321 318 322 }}} … … 354 358 355 359 su postgres 356 VACUUM 357 ANALYZE 360 psql -d evergreen 361 psql# VACUUM 362 psql# ANALYZE 358 363 }}} 359 364