likeilinux

likeilinux

关注
发信
关注(28)粉丝(399)

CentOS 7.2 安装postgresql95

  • libtool-ltdl-2.4.2-21.el7_2.x86_64.rpm
  • libxslt-1.1.28-5.el7.x86_64.rpm
  • pgdg-redhat95-9.5-2.noarch.rpm
  • postgresql95-9.5.5-1PGDG.rhel7.x86_64.rpm
  • postgresql95-contrib-9.5.5-1PGDG.rhel7.x86_64.rpm
  • postgresql95-devel-9.5.5-1PGDG.rhel7.x86_64.rpm
  • postgresql95-libs-9.5.5-1PGDG.rhel7.x86_64.rpm
  • postgresql95-odbc-09.05.0400-1PGDG.rhel7.x86_64.rpm
  • postgresql95-server-9.5.5-1PGDG.rhel7.x86_64.rpm
  • unixODBC-2.3.1-11.el7.x86_64.rpm
  • 配置ODBC数据源
    • 创建软链接
    [root@localhost ~]# ln -sf /usr/pgsql-9.5/bin/pg_config /usr/bin/pg_config
    [root@localhost ~]# ln -sf /usr/lib64/libodbcpsqlS.so /usr/lib/libodbcpsqlS.so
    [root@localhost ~]# ln -sf /usr/pgsql-9.5/lib/psqlodbcw.so /usr/lib64/psqlodbcw.so
    [root@localhost ~]# ln -sf /usr/pgsql-9.5/lib/psqlodbcw.so /usr/lib/psqlodbcw.so

    创建/etc/odbc.ini

    点击(此处)折叠或打开

    1. [freeswitch]
    2. Driver=PostgreSQL
    3. Database=freeswitch
    4. Servername=127.0.0.1
    5. Port=5432

    ODBC数据源测试：
        isql freeswitch freeswitch freeswitch

  • shell自动安装
    • 文件目录结构，其中odbc.ini内容如上节所示。

    点击(此处)折叠或打开

    1. [root@localhost postgresql]# tree
    2. .
    3. ├── ini
    4. │   └── odbc.ini
    5. ├── install-pgql95
    6. ├── libtool-ltdl-2.4.2-21.el7_2.x86_64.rpm
    7. ├── libxslt-1.1.28-5.el7.x86_64.rpm
    8. ├── pgdg-redhat95-9.5-2.noarch.rpm
    9. ├── postgresql95-9.5.5-1PGDG.rhel7.x86_64.rpm
    10. ├── postgresql95-contrib-9.5.5-1PGDG.rhel7.x86_64.rpm
    11. ├── postgresql95-devel-9.5.5-1PGDG.rhel7.x86_64.rpm
    12. ├── postgresql95-libs-9.5.5-1PGDG.rhel7.x86_64.rpm
    13. ├── postgresql95-odbc-09.05.0400-1PGDG.rhel7.x86_64.rpm
    14. ├── postgresql95-server-9.5.5-1PGDG.rhel7.x86_64.rpm
    15. ├── readme.txt
    16. ├── sql
    17. │   ├── mod_cdr_pg_csv.sql
    18. │   └── mod_cidlookup.sql
    19. └── unixODBC-2.3.1-11.el7.x86_64.rpm

    21. 2 directories, 15 files
    22. [root@localhost postgresql]#
    postgresql95安装字段安装脚本名 install-pgql95，使用 sh install-pgql95 执行脚本进行安装
    在线安装脚本（install-pgql95）

    点击(此处)折叠或打开

    1. #!/bin/bash


    4. DATE=`date +'%Y-%m%d-%H%M'`

    6. UOUT="/tmp/install-pgql95.out"

    8. if [ -f $UOUT ];then
    9.   echo "script has already been executed. "
    10.   exit 0
    11. fi


    14. hm=$(echo $0 |sed 's/install-pgql95//')
    15. [[ ! -z $hm ]] && cd $hm

    17. HOME_DIR=`pwd`

    19. echo "Entering into $HOME_DIR, use yum install postgresql95, please wait ..."

    21. yum install http://yum.postgresql.org/9.5/redhat/rhel-7-x86_64/pgdg-redhat95-9.5-2.noarch.rpm >>${UOUT} 2>&1

    23. yum install -y postgresql95-server postgresql95-contrib postgresql95-devel postgresql95-odbc >>${UOUT} 2>&1

    25. echo "postgresql95 initdb ..."
    26. /usr/pgsql-9.5/bin/postgresql95-setup initdb >>${UOUT} 2>&1

    28. sed -i 's/127.0.0.1\/32 ident/0.0.0.0\/0 md5/g' /var/lib/pgsql/9.5/data/pg_hba.conf
    29. sed -i 's/localhost/*/g' /var/lib/pgsql/9.5/data/postgresql.conf
    30. sed -i 's/#listen_addresses/listen_addresses/g' /var/lib/pgsql/9.5/data/postgresql.conf
    31. #sed -i 's%#listen_addresses = 'localhost'%listen_addresses = '*'%g' /var/lib/pgsql/9.5/data/postgresql.conf
    32. ## listen_addresses = '*'


    35. ln -sf /usr/pgsql-9.5/bin/pg_config /usr/bin/pg_config

    37. ln -sf /usr/lib64/libodbcpsqlS.so /usr/lib/libodbcpsqlS.so

    39. ln -sf /usr/pgsql-9.5/lib/psqlodbcw.so /usr/lib64/psqlodbcw.so

    41. ln -sf /usr/pgsql-9.5/lib/psqlodbcw.so /usr/lib/psqlodbcw.so

    43. echo "start posrtgresql-9.5 ..."
    44. systemctl enable postgresql-9.5.service >>${UOUT} 2>&1

    46. systemctl start postgresql-9.5.service >>${UOUT} 2>&1

    48. sleep 3

    50. su - postgres -c "psql -c \" ALTER USER postgres WITH PASSWORD 'postgres';\"" >>${UOUT} 2>&1
    51. su - postgres -c "psql -c \" CREATE USER freeswitch WITH PASSWORD 'freeswitch';\"" >>${UOUT} 2>&1
    52. su - postgres -c "psql -c \" CREATE DATABASE freeswitch;\"" >>${UOUT} 2>&1
    53. su - postgres -c "psql -c \" ALTER DATABASE freeswitch OWNER TO freeswitch;\"" >>${UOUT} 2>&1
    54. su - postgres -c "psql -c \" GRANT ALL PRIVILEGES ON DATABASE freeswitch to freeswitch;\"" >>${UOUT} 2>&1

    56. for sqlfile in $HOME_DIR/sql/*.sql
    57. do
    58.   echo "execute sql file : "$sqlfile
    59.   su - postgres -c "psql -d freeswitch -f $sqlfile" >>${UOUT} 2>&1
    60. done

    62. if [ -f /etc/odbc.ini ];then
    63.   if [ -f /etc/odbc.ini.bak ];then
    64.     rm -rf /etc/odbc.ini.bak
    65.   fi
    66.   mv /etc/odbc.ini /etc/odbc.ini.bak
    67. fi

    69. /bin/cp -rf $HOME_DIR/ini/odbc.ini /etc/odbc.ini

    71. echo "you can use 'isql freeswitch freeswitch freeswitch' to test odbc"

    离线安装脚本（install-pgql95）

    点击(此处)折叠或打开

    1. #!/bin/bash


    4. DATE=`date +'%Y-%m%d-%H%M'`

    6. UOUT="/tmp/install-pgql95.out"

    8. if [ -f $UOUT ];then
    9.   echo "script has already been executed. "
    10.   exit 0
    11. fi


    14. hm=$(echo $0 |sed 's/install-pgql95//')
    15. [[ ! -z $hm ]] && cd $hm

    17. HOME_DIR=`pwd`

    19. echo "Entering into $HOME_DIR, install rpms ..."
    20. rpm_dir=$HOME_DIR/"*.rpm"
    21. for i in $rpm_dir
    22. do
    23.   rpm -Uvh --nodeps $i >>${UOUT} 2>&1
    24. done

    26. echo "postgresql95 initdb ..."
    27. /usr/pgsql-9.5/bin/postgresql95-setup initdb >>${UOUT} 2>&1

    29. sed -i 's/127.0.0.1\/32 ident/0.0.0.0\/0 md5/g' /var/lib/pgsql/9.5/data/pg_hba.conf
    30. sed -i 's/localhost/*/g' /var/lib/pgsql/9.5/data/postgresql.conf
    31. sed -i 's/#listen_addresses/listen_addresses/g' /var/lib/pgsql/9.5/data/postgresql.conf
    32. #sed -i 's%#listen_addresses = 'localhost'%listen_addresses = '*'%g' /var/lib/pgsql/9.5/data/postgresql.conf
    33. ## listen_addresses = '*'


    36. ln -sf /usr/pgsql-9.5/bin/pg_config /usr/bin/pg_config

    38. ln -sf /usr/lib64/libodbcpsqlS.so /usr/lib/libodbcpsqlS.so

    40. ln -sf /usr/pgsql-9.5/lib/psqlodbcw.so /usr/lib64/psqlodbcw.so

    42. ln -sf /usr/pgsql-9.5/lib/psqlodbcw.so /usr/lib/psqlodbcw.so

    44. echo "start posrtgresql-9.5 ..."
    45. systemctl enable postgresql-9.5.service >>${UOUT} 2>&1

    47. systemctl start postgresql-9.5.service >>${UOUT} 2>&1

    49. sleep 3

    51. su - postgres -c "psql -c \" ALTER USER postgres WITH PASSWORD 'postgres';\"" >>${UOUT} 2>&1
    52. su - postgres -c "psql -c \" CREATE USER freeswitch WITH PASSWORD 'freeswitch';\"" >>${UOUT} 2>&1
    53. su - postgres -c "psql -c \" CREATE DATABASE freeswitch;\"" >>${UOUT} 2>&1
    54. su - postgres -c "psql -c \" ALTER DATABASE freeswitch OWNER TO freeswitch;\"" >>${UOUT} 2>&1
    55. su - postgres -c "psql -c \" GRANT ALL PRIVILEGES ON DATABASE freeswitch to freeswitch;\"" >>${UOUT} 2>&1

    57. for sqlfile in $HOME_DIR/sql/*.sql
    58. do
    59.   echo "execute sql file : "$sqlfile
    60.   su - postgres -c "psql -d freeswitch -f $sqlfile" >>${UOUT} 2>&1
    61. done

    63. if [ -f /etc/odbc.ini ];then
    64.   if [ -f /etc/odbc.ini.bak ];then
    65.     rm -rf /etc/odbc.ini.bak
    66.   fi
    67.   mv /etc/odbc.ini /etc/odbc.ini.bak
    68. fi

    70. /bin/cp -rf $HOME_DIR/ini/odbc.ini /etc/odbc.ini

    72. echo "you can use 'isql freeswitch freeswitch freeswitch' to test odbc"


    01-16 04:22
    Powered by LMLPHP ©2024 likeilinux 0.064215