centos対象
# yum install postgresql-server # yum install postgresql # yum install httpd # yum install php # yum install php-pgsql
# su - postgres $ #rm -r data $ initdb --encoding=UTF8 --no-locale -D /var/lib/pgsql/data $ pg_ctl start $ createuser --pwprompt --superuser --createdb --no-createrole xxusrxx $ psql -c 'create database xxdbxx with owner = xxusrxx;' postgres $ psql -c 'create schema xxschxx authorization xxusrxx;' -d xxdbxx -U xxusrxx
# chkconfig --add postgresql # chkconfig postgresql on
# /etc/init.d/httpd start
# chkconfig --add httpd # chkconfig httpd on
vim /etc/sysconfig/iptables
# Firewall configuration written by system-config-firewall # Manual customization of this file is not recommended. *filter :INPUT ACCEPT [0:0] :FORWARD ACCEPT [0:0] :OUTPUT ACCEPT [0:0] -A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT -A INPUT -p icmp -j ACCEPT -A INPUT -i lo -j ACCEPT -A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT -A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT -A INPUT -j REJECT --reject-with icmp-host-prohibited -A FORWARD -j REJECT --reject-with icmp-host-prohibited COMMIT
変更後
# /etc/init.d/iptables stopt # /etc/init.d/iptables start
/etc/httpd/conf.d/php.conf の内容を確認(なにもしなくても動くはず)
/etc/sysconfig/i18n
* 日本語
LANG="ja_JP.UTF-8"