PostgeSQL6.5.3
Make the postgres user
groupadd -g 201 postgres
useradd -u 201 -g postgres postgres
Make the directory for install
mkdir /usr/local/pgsql
chown postgres:postgres /usr/local/pgsql/
Uncompress
su - postgres
tar xvzf postgresql-6.5.3.tar.gz
cd postgresql-6.5.3/src
Prepare for compilation
./configure --with-perl --with-odbc
Install the documents
cd ../doc
gmake install
Compile & Install
cd ../src
gmake all
gmake install
Add to Shared Library
su -
vi /etc/ld.so.conf
/usr/X11R6/lib
/usr/i486-linux-libc5/lib
/usr/local/pgsql/lib
ldconfig
exit
Install Perl Module
I think the perl module was not installed, because of the permission.
su
cd interfaces/perl5
gmake install
exit
Configure the Environment Valiables
cat >> ~/.bash_profile <<EOF
PATH=$PATH:/usr/local/pgsql/bin
MANPATH=$MANPATH:/usr/local/pgsql/man
PGLIB=/usr/local/pgsql/lib
PGDATA=/share02/data <-- place of the DB
export PATH MANPATH PGLIB PGDATA
EOF
get the environmant vals
source ~/.bash_profile
Initialize DB
Run on the postgres user not on the root user
initdb
Configure the permisson of the DB
vi /share02/data/pg_hba.conf
I didn't change at all because I'd use only in my room. :P
Run the DB and some tests
cd
nohup postmaster -i > pgserver.log 2>&1 &
createdb
psql
postgres=> select datetime 'now';
?column?
----------------------------
Sat Sep 23 20:27:27 2000 JST
(1 row)
destroydb
Configure to start automatically at boot time
cd
su
cp postgresql-6.5.3/contrib/linux/postgres.init.sh /etc/rc.d/init.d/postgres
ln -s /etc/rc.d/init.d/postgres /etc/rc.d/rc3.d/S98postgres
ln -s /etc/rc.d/init.d/postgres /etc/rc.d/rc5.d/S98postgres
exit
regression test
cd
cd postgresql-6.5.3/src/test/regress
gmake clean
gmake all runtest
destroydb regression
gmake clean
$Lastupdate: 2000/10/27 (Fri) 02:34:07 $
[home]
[install]