# apt-get install gcc # apt-get install libc6-dev # apt-get install libssl-dev # apt-get install bison # apt-get install flex # apt-get install make # apt-get install libreadline-dev # apt-get install zlib1g-dev
# mkdir /var/lib/postgres # chown postgres:postgres /var/lib/postgres
# groupdadd postgres # useradd -m -g postgres postgres
http://www.postgresql.org/ftpsite/v7.3.2/postgresql-7.3.2.tar.gz
# cd /usr/local/src # tar -xvzf postgresql-7.3.2.tar.gz # cd postgresql-7.3.2 # ./configure --with-openssl # make # make install # cd /usr/local/pgsql # mkdir data # chown postgres:postgres data # chmod 700 data
export POSTGRES_HOME=/usr/local/pgsql export PGDATA=$POSTGRES_HOME/data export PATH=$PATH:$POSTGRES_HOME/bin export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$POSTGRES_HOME/lib
# su - postgres # initdb -E UNICODE --no-locale/usr/local/pgsql/data/postgresql.conf に以下を追加する
tcpip_socket = true syslog = 2
# su - postgres $ pg_ctl start
# su - postgres $ pg_ctl stop
(ここでは wbt というデータベースを作っている) # su - postgres $ psql template1 template1=# CREATE DATABASE wbt; template1=# CREATE USER wbt WITH PASSWORD 'xxxxxxxx'; template1=# \q
export PGCLIENTENCODING=EUC_JP
$Id: postgresql.html,v 1.12 2003/04/15 08:32:56 sugiyama Exp $ Copyright (c) 2002-2003 Hidenori Sugiyama