1. 文章
  2. 基础运维

企业级PG：EnterpriseDB的安装使用

Stephev · 2018-12-03 18:31:40发表 · 7236 次点击
   1    1   

概述

EnterpriseDB是全球唯一一家提供基于PostgreSQL企业级产品与服务的厂商
EnterpriseDB是PostgreSQL的一个分支，在PostgreSQL基础上，针对企业级应用进行了专门的优化，同时，增加了一系列如动态 性能调优（DynaTune）、EDB Loader、高效批量SQL处理等高级特性；在众多功能亮点中，EnterpriseDB的兼容性技术尤为惹眼，可以兼容oracle的数据库，目前，IBM 的DB2的数据库直接用EnterpriseDB的兼容包。

下载

EDB官网 www.enterprisedb.com
下载需要申请账号密码
本来是想选择最新的PG11，但是系统版本只是支持Windows，这里我们选择的是10.5，可以安装在Linux 64位系统上。

安装

将安装包上传

将安装包上传到已经准备好的系统上，并赋予执行权限

  1. [root@stephen opt]# chmod +x edb-as10-server-10.5.12-1-linux-x64.run

执行run安装文件

  1. [root@stephen opt]# ./edb-as10-server-10.5.12-1-linux-x64.run 
  2. ----------------------------------------------------------------------------
  3. Welcome to the EDB Postgres Advanced Server Setup Wizard.
  5. ----------------------------------------------------------------------------
  6. Please read the following License Agreement. You must accept the terms of this 
  7. agreement before continuing with the installation.
  9. Press [Enter] to continue:
  10. Limited Use Software License Agreement
  11. Version 2.9
  13. ............................................(忽略这些声明)
  15. Press [Enter] to continue:
  17. Do you accept this license? [y/n]: y
  19. ----------------------------------------------------------------------------
  20. Please specify the directory where EDB Postgres Advanced Server will be 
  21. installed.
  23. Installation Directory [/opt/edb/as10]: /opt/edb/as10   
  24. # 选择要安装到的路径，全路径，如例
  26. ----------------------------------------------------------------------------
  27. Select the components you want to install; clear the components you do not want
  28. to install. Click Next when you are ready to continue.
  29. # 手动选择一些需要安装的东西，这里我随便选了几样，可以根据需要选择安装
  31. EDB Postgres Advanced Server [Y/n] :y
  33. pgAdmin 4 [Y/n] :y
  35. StackBuilder Plus [Y/n] :n
  37. Command Line Tools [Y/n] :y
  39. Is the selection above correct? [Y/n]: y
  41. ----------------------------------------------------------------------------
  42. Additional Directories
  44. Please select a directory under which to store your data.
  46. Data Directory [/opt/edb/as10/data]: /sas_pgdata
  48. Please select a directory under which to store your Write-Ahead Logs.
  50. Write-Ahead Log (WAL) Directory [/opt/edb/as10/data/pg_wal]: /opt/edb/as10/data/pg_wal
  51. # 这里是选择wal放的地方，理论上来说最好是将这个放在pgdata的位置，也就是数据目录里，我安装的时候没太注意，不过影响也不大，各位在安装的时候推荐放在数据目录下
  52. ----------------------------------------------------------------------------
  53. Advanced Server Dialect
  55. EDB Postgres Advanced Server can be configured in one of two "Dialects" - 1) Compatible with Oracle or 2) Compatible with Postgres.
  57. If you select Compatible with Oracle, Advanced Server will be configured with appropriate data type conversions, time and date formats, Oracle-styled operators, dictionary views and more. This makes it easier to migrate or write new applications that are more compatible with the Oracle database.
  59. If you select Compatible with Postgres, Advanced Server will be configured with standard PostgeSQL data types, time/date formats and operators.
  61. Advanced Server Dialect
  63. [1] Compatible with Oracle
  64. [2] Compatible with Postgres
  65. Please choose an option [1] : 2
  67. #这里是选择高级服务器可以配置两种方言（Dialects），我更熟悉PG一点，所以选择2
  69. ----------------------------------------------------------------------------
  70. Please provide a password for the database superuser (postgres). A locked Unix 
  71. user account (postgres) will be created if not present.
  73. #给postgres超级用户一个密码
  75. Password :
  76. Retype Password :
  77. ----------------------------------------------------------------------------
  78.  Additional Configuration
  80. Please select the port number the server should listen on.
  82. Port [5432]: 5444
  84. # 因为安装的系统还有一个postgres数据库，选择换一个端口进行安装
  86. Select the locale to be used by the new database cluster.
  88. Locale
  91. Please choose an option [1] : 
  93. Would you like to install sample tables and procedures?
  95. Install sample tables and procedures. [Y/n]: y
  98. ----------------------------------------------------------------------------
  99. Dynatune Dynamic Tuning:
  100. Server Utilization
  102. Please select the type of server to determine the amount of system resources 
  103. that may be utilized:
  105. #请选择服务器类型以确定系统资源的数量
  106. #[1]开发(例如开发人员的笔记本电脑)
  107. #[2]通用(例如web或应用服务器)
  108. #[3]专用的(只运行高级服务器的服务器)
  109. #这里我们只是安装测试，所以就选择1
  112. [1] Development (e.g. a developer's laptop)
  113. [2] General Purpose (e.g. a web or application server)
  114. [3] Dedicated (a server running only Advanced Server)
  115. Please choose an option [2] : 1
  117. ----------------------------------------------------------------------------
  118. Dynatune Dynamic Tuning:
  119. Workload Profile
  121. Please select the type of workload this server will be used for:
  123. #选择工作概要
  124. #[1]事务处理(OLTP系统)
  125. #[2]通用(OLTP和报告工作负载)
  126. #[3]报告(复杂查询或OLAP工作负载)
  127. #选择安装数据库用来做工作的类型，我这里这里选择2
  129. [1] Transaction Processing (OLTP systems)
  130. [2] General Purpose (OLTP and reporting workloads)
  131. [3] Reporting (Complex queries or OLAP workloads)
  132. Please choose an option [1] : 2
  134. ----------------------------------------------------------------------------
  135. Pre Installation Summary
  137. The following settings will be used for the installation::
  139. Installation Directory: /opt/edb/as10
  140. Server Installation Directory: /opt/edb/as10
  141. Data Directory: /sas_pgdata
  142. WAL Directory: /opt/edb/as10/data/pg_wal
  143. Database Port: 5432
  144. Database Superuser: postgres
  145. Operating System Account: postgres
  146. Database Service: edb-as-10
  147. Command Line Tools Installation Directory: /opt/edb/as10
  148. pgAdmin4 Installation Directory: /opt/edb/as10/pgAdmin4
  150. Press [Enter] to continue:
  152. #确认安装信息
  154. ----------------------------------------------------------------------------
  155. Setup is now ready to begin installing EDB Postgres Advanced Server on your 
  156. computer.
  158. Do you want to continue? [Y/n]: y
  160. ----------------------------------------------------------------------------
  161. Please wait while Setup installs EDB Postgres Advanced Server on your computer.
  163.  Installing EDB Postgres Advanced Server 
  164.  0% ______________ 50% ______________ 100%
  165.  #########################################
  167. ----------------------------------------------------------------------------
  168. Setup has finished installing EDB Postgres Advanced Server on your computer.
  170. #安装完毕

配置环境

新建用户edb

为了方便使用和管理，我们新建edb用户来使用edb。

  1. useradd -U edb

然后将安装好的安装目录和数据目录赋予用户权限

  1. chown -R edb:edb /opt/edb/
  2. chown -R edb:edb /sas_pgdata

配置环境变量

将新建的环境变量加到.bash_profile中

  1. export PATH=/opt/edb/as10/bin:$PATH
  2. export LD_LIBRARY_PATH=/opt/edb/as10/lib:$LD_LIBRARY_PATH
  3. export PGDATA=/sas_pgdata
  4. export PGHOST=/tmp

启动edb数据库

启动数据库

  1. [edb@stephen ~]$ pg_ctl start
  2. waiting for server to start....2018-12-03 11:01:01 CST LOG:  listening on IPv4 address "0.0.0.0", port 5444
  3. 2018-12-03 11:01:01 CST LOG:  listening on IPv6 address "::", port 5444
  4. 2018-12-03 11:01:01 CST LOG:  listening on Unix socket "/tmp/.s.PGSQL.5444"
  5. 2018-12-03 11:01:01 CST LOG:  redirecting log output to logging collector process
  6. 2018-12-03 11:01:01 CST HINT:  Future log output will appear in directory "log".
  7.  done
  8. server started

查看数据库是否正常

  1. [edb@stephen ~]$ psql -Upostgres
  2. Password for user postgres: 
  3. psql.bin (10.5.12)
  4. Type "help" for help.
  6. postgres=# 
  7. postgres=# \d
  8.              List of relations
  9.  Schema |    Name    |   Type   |  Owner   
  10. --------+------------+----------+----------
  11.  public | dept       | table    | postgres
  12.  public | emp        | table    | postgres
  13.  public | jobhist    | table    | postgres
  14.  public | next_empno | sequence | postgres
  15.  public | salesemp   | view     | postgres
  16. (5 rows)
  18. postgres=# \l
  19.                                      List of databases
  20.    Name    |  Owner   | Encoding |   Collate   |    Ctype    | ICU |   Access privileges   
  21. -----------+----------+----------+-------------+-------------+-----+-----------------------
  22.  postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |     | 
  23.  template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |     | =c/postgres          +
  24.            |          |          |             |             |     | postgres=CTc/postgres
  25.  template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |     | =c/postgres          +
  26.            |          |          |             |             |     | postgres=CTc/postgres
  27. (3 rows)
  29. postgres=# \q

查看数据库后台进程是否正常

  1. [edb@stephen ~]$ ps -ef|grep edb
  2. postgres  3668     1  0 10:45 ?        00:00:00 /opt/edb/as10/bin/edb-postgres -D /sas_pgdata
  3. root      4007  2079  0 10:57 pts/1    00:00:00 su - edb
  4. edb       4008  4007  0 10:57 pts/1    00:00:00 -bash
  5. edb       4112     1  0 11:01 pts/1    00:00:00 /opt/edb/as10/bin/edb-postgres
  6. edb       4113  4112  0 11:01 ?        00:00:00 postgres: logger process   
  7. edb       4129  4112  0 11:01 ?        00:00:00 postgres: checkpointer process  
  8. edb       4130  4112  0 11:01 ?        00:00:00 postgres: writer process   
  9. edb       4131  4112  0 11:01 ?        00:00:00 postgres: wal writer process  
  10. edb       4132  4112  0 11:01 ?        00:00:00 postgres: autovacuum launcher process  
  11. edb       4133  4112  0 11:01 ?        00:00:00 postgres: stats collector process  
  12. edb       4134  4112  0 11:01 ?        00:00:00 postgres: bgworker: dbms_aq launcher  
  13. edb       4135  4112  0 11:01 ?        00:00:00 postgres: bgworker: logical replication launcher  
  14. edb       4165  4008  0 11:02 pts/1    00:00:00 ps -ef
  15. edb       4166  4008  0 11:02 pts/1    00:00:00 grep --color=auto edb
本站文章，未经作者同意，请勿转载，如需转载，请邮件customer@csudata.com.
0 评论  
添加一条新评论

用户登录

个人首页
立即登录