solaris​/postgresql

# vi /etc/system

set shmsys:shminfo_shmmax=1677721600
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100

# shutdown -i6 -g0 -y
# useradd -d /export/home/posgres -m -s /usr/local/bin/bash postgres
# cd /usr/local/arch
# wget ftp://ftp3.us.postgresql.org/pub/postgresql/source/postgresql-8.0.4.tar.gz
# cd ../src
# tar xvzf ../arch/postgresql-8.0.4.tar.gz
# chown -R postgrespostgresql-8.0.4
# mkdir /usr/local/pgsql
# chown postgres /usr/local/pgsql
# su - postgres
$ cd /usr/local/src/postgresql-8.0.4
$ export PATH=/usr/ccs/bin:${PATH}
$ export LD_LIBRARY_PATH=/usr/ccs/lib:/usr/local/lib:${LD_LIBRARY_PATH}
$ ./configure
$ make
$ make install

$ cd /usr/local/pgsql
$ mkdir data
$ bin/initdb -E EUC_JP --no-locale -D /usr/local/pgsql/data
$ cd data
$ vi postgresql.conf

listen_addresses='192.168.0.1'
port=5432
max_connections=30
ssl=false
password_encryption=true
shared_buffers=4000

log_destination = 'syslog,stderr'
redirect_stderr = true
log_directory = 'pg_log'
log_filename = 'postgresql-%Y%m%d.log'
syslog_facility = 'LOCAL3'
log_min_error_statement = error

$ vi pg_hba.conf

local all all              md5
host  all all 127.0.0.1/32 md5

$ /usr/local/pgsql/bin/pg_ctl start
$ createdb postgres
$ psql
$ pg_ctl stop
$ pg_ctl -m f stop

$ pg_dump olddb > pgsql.dmp
$ createdb newdb
$ psql -e newdb < pgsql.dmp

$ createdb -E UTF-8 utfdb
$ psql utfdb
utfdb=# set client_encoding to EUC_JP;
SET
utfdb=# set client_encoding to UNICODE;
SET
utfdb=# \set
VERSION = 'PostgreSQL 8.0.4 on i386-pc-solaris2.8, compiled by GCC 2.95.2'
AUTOCOMMIT = 'on'
VERBOSITY = 'default'
PROMPT1 = '%/%R%# '
PROMPT2 = '%/%R%# '
PROMPT3 = '>> '
DBNAME = 'utfdb'
USER = 'postgres'
PORT = '5432'
ENCODING = 'UNICODE'
HISTSIZE = '500'
LASTOID = '0'

# su - postgres
$ createlang -p 5432 -d tvtdb plpgsql