postgresql-資料

1.下載
ver=9.1.3 ;cd /app; wget  http://ftp.postgresql.org/pub/source/v$ver/postgresql-$ver.tar.gz ；
2.安裝-1

1. #/bin/sh
   
2. ver=9.1.3
   
3. cp /app/sysctl.conf /etc
   
4. rm -r /usr/local/pgsql
   
5. rm -r /usr/src/postgresql*
   
6. mkdir /usr/local/pgsql
   
7. cd /usr/src/
   
8. tar -zxvf /app/postgresql-$ver.tar*
   
9. groupadd pgsql_user
   
10. useradd  pgsql_user -g pgsql_user
    
11. mkdir /home/pgsql_user
    
12. chown -R pgsql_user             /home/pgsql_user
    
13. chown -R pgsql_user:pgsql_user  /usr/local/pgsql
    
14. chown -R pgsql_user:pgsql_user  /usr/src/pgsql
    
15. cp /app/bash_profile /home/pgsql_user/.bash_profile
    
16. mkdir /etc/rc.d/run
    
17. cp /app/rc.d/run/* /etc/rc.d/run
    
18. chmod 755 /etc/rc.d/run/*
    
19. login pgsql_user
    
20. 3.安裝-2
    
21. #!/bin/sh
    
22. cd /usr/src/postgresql*
    
23. ./configure --enable-odbc --prefix=/usr/local/pgsql --enable-multibyte --enable-locale
    
24. make;make install;
    
25. cd /usr/src/pgsql/doc
    
26. make install;
    
27. initdb
    
28. cp /lin_app/pg_hba.conf /usr/local/pgsql/data
    
29. postgres -D /usr/local/pgsql/data &
    
30. createuser admin
    
31. createuser pgsql

复制代码

4.執行-- /etc/rc.d/rc.pgsql

1. #!/bin/sh
   
2. #
   
3. # /etc/rc.d/rc.pgsql:  Local system initialization script.
   
4. #
   
5. # Put any local setup commands in here:
   
6. echo "Start Postgres SQL Server........"
   
7. if [ -x /tmp/.s.PGSQL.5432 ]; then
   
8.         rm /tmp/.s.PGSQL.5432
   
9. fi
   
10. su pgsql_user -c 'exec /usr/local/pgsql/bin/postmaster -i -D/usr/local/pgsql/data &'

复制代码