Monday, May 17, 2010

postgresql setup

600 cd /var/lib/pgsql/
601 ls -lh
602 df -h
603 cd ..
604 ls
605 ls -lh
606 pwd
607 mv pgsql /opt/
608 ln -s /opt/pgsql /var/lib/pgsql
609 ls -lah
610 ls /opt/pgsql/
611 service postgresql initdb
612 serservice postgresql start
613 service postgresql start
614 chkconfig postgresql on

peerce: su - postgres
(7:36:56 PM) peerce: psql
(7:37:05 PM) peerce: create user fred; create database fred owner fred;
(7:37:09 PM) peerce: \q
(7:37:12 PM) peerce: ^d



tune shmmax
http://www.postgresql.org/docs/current/static/kernel-resources.html
# getconf PAGE_SIZE
4096

No comments: