1. HardWare V100
Sun Fire V100 (UltraSPARC-IIe 548MHz), No Keyboard
OpenBoot 4.0, 512 MB memory installed, Serial #53480306.
Ethernet address 0:3:ba:30:b:72, Host ID: 83300b72.
2. OS Solaris8
SunOS Release 5.8 Version Generic_117350-39 64-bit Solaris 8
# uname -a
SunOS bjgdj-nsm 5.8 Generic_117350-39 sun4u sparc SUNW,UltraAX-i2
3. Tools
SecureCRT 5.1 连接ALOM
XManager2 图形终端和FTP
modify
vi /etc/default/login
# If CONSOLE is set, root can only login on that device.
# Comment this line out to allow remote login by root.
#CONSOLE=/dev/console
# SUPATH sets the initial shell PATH variable for root
SUPATH=/usr/sbin:/usr/bin:/usr/local/bin
8. Install PostgreSQl www.postgresql.org
8.1 download postgresql-8.1.4.tar.gz
8.2 unzip gunzip postgresql-8.1.4.tar.gz; tar -xvf postgresql-8.1.4.tar ; 放到 /opt/Jedi/Tools
8.3 useradd -c 'PostgreSQL user' -d /opt/Jedi/postgres -m -s /bin/bash postgres
8.4 /opt/Jedi/Tools/postgresql-8.1.4/configures --prefix =/opt/Jedi/postgres
8.5 make;
8 .6 make Installer;
8.7 chmod -R 755 /opt/Jedi/postgres
8.8 vi /etc/system --Edit System Params
set shmsys:shminfo_shmmax=0x2000000
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=256
set shmsys:shminfo_shmseg=256
set semsys:seminfo_semmap=256
set semsys:seminfo_semmni=512
set semsys:seminfo_semmns=512
set semsys:seminfo_semmsl=32
sync; reboot;
8 .9 su - postgres
8 .10 vi .profile
LD_LIBRARY_PATH=$HOME/lib:/usr/local/lib
export LD_LIBRARY_PATH
. ./.profile
8 .11 initdb -D ../data 初始化数据库
8 .12 pgctl start -D ../data 启动数据库
8 .13 #: PSQL 创建数据库
postgres-# CREATE DATABASE "Jedi_SafeNet" WITH OWNER = postgres
ENCODING = 'UTF8' TABLESPACE = pg_default;
8 .14 测试 postgres=# select current_date;
date
------------
2006-07-22
8 .15 vi /data/postgresql.conf
# - Connection Settings
listen_addresses = '*'
# what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
port = 5432
max_connections = 20
vi /data/postgresql.conf
# IPv4 local connections:
# host all all 127.0.0.1/32 trust
host all all 192.168.0.0/24 password
8 .16 cat /opt/Jedi/Tools/postgresql-8.1.4/doc/
Contents:
1) What tools do I need to build and install PostgreSQL on Solaris?
- GNU zip (for installing the documentation)
- GNU make
- GNU readline library (optional)
2) Why do I get problems when building with OpenSSL support?
3) Why does configure complain about a failed test program?
4) Why does my 64-bit build sometimes crash?
LD_LIBRARY_PATH=/usr/local/lib:/usr/local/ssl/lib
export LD_LIBRARY_PATH
5) How can I compile for optimum performance?
Try using the "-fast" compile flag.
9. AUTO Startup
9 .1 vi /etc/init.d/postgres
#!/sbin/sh
# write by ww 06/07/23 BJ"
#LD_LIBRARY_PATH=/usr/local/lib; export LD_LIBRARY_PATH
case "$1" in
'start')
su - postgres -c ". ./.profile; ./bin/pg_ctl start -D ./data"
;;
'stop')
su - postgres -c ". ./.profile; ./bin/pg_ctl stop -W -D ./data -m fast"
exit 1
;;
esac
exit 0
#chmod 744 postgres
#ln -s /etc/init.d/postgres /etc/rc2.d/S65postgres
#ln -s /etc/init.d/postgres /etc/rc0.d/K65postgres
9 .1 vi /etc/init.d/tomcat
#!/sbin/sh
# write by ww 06/07/23 BJ"
#JAVA_HOME=/opt/SUNWappserver/jdk;export JAVA_HOME
case "$1" in
'start')
su - root -c ". ./.profile; /opt/Jedi/tomcat/bin/startup.sh"
;;
'stop')
su - root -c ". ./.profile; /opt/Jedi/tomcat/bin/shutdown.sh"
exit 1
;;
esac
exit 0
# chmod 744 tomcat
#ln -s /etc/init.d/tomcat /etc/rc2.d/S60tomcat
#ln -s /etc/init.d/tomcat /etc/rc0.d/K60tomcat