software, business, and fun
cambodia

Category — Braindump

apache mpm-worker or mpm-prefork

PHP5 requires prefork. mpm-worker is more efficient, prefork is for nonthreadsafe libs. apt-get wouldn’t let me install mod_php unless i changed to prefork.

http://www.gra2.com/article.php/improving-performance-rails-apache2

mod_fcgid is a possibility, but I did not want to go there.

August 10, 2007   No Comments

apt-get/dselect reference

dpkg -l
list all installed packages

August 10, 2007   No Comments

simple postgresql cli commands:

psql -d dbname -u

\? help
\d = describe
\d tablename

dump a database:

travis@debian~ $ pg_dump -d dbname -u > out.sql

prompts for user/pass

August 10, 2007   No Comments