Share Pastebin
Guest
Public paste!

jalankan ini az..

By: a guest | Mar 19th, 2010 | Syntax: Bash | Size: 1.91 KB | Hits: 107 | Expires: Never
Copy text to clipboard
  1. #!/bin/bash
  2. idir=/home/`whoami`/Repository/postgres
  3. mkdir -p $idir
  4. cd $idir
  5. ifile=/home/`whoami`/.cvspass
  6. if [ ! -e "$ifile" ] ; then
  7.   echo "enter any password other than blank.."
  8.   cvs -d :pserver:anoncvs@anoncvs.postgresql.org:/projects/cvsroot login
  9.   cvs -z3 -d :pserver:anoncvs@anoncvs.postgresql.org:/projects/cvsroot co -P pgsql
  10. fi
  11. cd pgsql
  12. cvs -z3 update -d -P
  13. idir=/home/`whoami`/Software/PostgreSQL-9
  14. ./configure --with-pam --with-openssl --with-libxml --with-libxslt --prefix=$idir && make && make install
  15. mkdir -p $idir
  16. sudo chown postgres $idir
  17. sudo su -p postgres -c "$idir/bin/initdb -D $idir/data"
  18. ifile=$idir/data/postgresql.conf
  19. param="s/#listen_addresses = 'localhost'/listen_addresses = 'localhost'/"
  20. sudo sed -i "$param" $ifile
  21. param='s/#port = 5432/port = 5432/'
  22. sudo sed -i "$param" $ifile
  23. param="s/#unix_socket_directory = ''/unix_socket_directory = '\/tmp'/"
  24. sudo sed -i "$param" $ifile
  25. param='s/#ssl = off/ssl = true/'
  26. sudo sed -i "$param" $ifile
  27. param='s/#password_encryption = on/password_encryption = on/'
  28. sudo sed -i "$param" $ifile
  29. ifile=$idir/data/server
  30. if [ "`sudo ls $ifile.key`" != "$ifile.key" ] ; then
  31.   sudo openssl req -new -text -out $ifile.req
  32.   sudo openssl rsa -in privkey.pem -out $ifile.key
  33.   sudo rm privkey.pem
  34.   sudo openssl req -x509 -in $ifile.req -text -key $ifile.key -out $ifile.crt
  35.   sudo chmod og-rwx $ifile.key
  36.   sudo chown postgres:postgres $ifile.key
  37.   echo 'NOTE: start PostgreSQL9 before entering password using this command on another terminal session:'
  38.   echo "sudo su -p postgres -c '$idir/bin/postgres -D $idir/data'"
  39.   sudo su -p postgres -c 'createuser -esP $SUDO_USER && createdb -eO $SUDO_USER $SUDO_USER'
  40. fi
  41. ifile=/usr/local/lib
  42. for x in `ls $idir/lib` ; do
  43.   sudo rm -f $ifile/$x
  44.   sudo ln -s $idir/lib/$x $ifile/
  45. done
  46. ifile=/usr/local/bin
  47. for x in `ls $idir/bin` ; do
  48.   sudo rm -f $ifile/$x
  49.   sudo ln -s $idir/bin/$x $ifile/
  50. done