CentOS7.8离线搭建CDH6.2.0集群（二）

续前篇《CentOS7.8离线搭建CDH6.2.0集群（一）》

数据库安装与配置（PostgresQL）

1.数据库安装

[root@localhost pgsql]# pwd
/home/pgsql
[root@localhost pgsql]# ls -l
总用量 6424
-rw-r--r--. 1 root root 1512696 1月   6 23:03 postgresql96-9.6.20-2PGDG.rhel7.x86_64.rpm
-rw-r--r--. 1 root root  329424 1月   6 23:03 postgresql96-libs-9.6.20-2PGDG.rhel7.x86_64.rpm
-rw-r--r--. 1 root root 4728756 1月   6 23:03 postgresql96-server-9.6.20-2PGDG.rhel7.x86_64.rpm
[root@localhost pgsql]# rpm -ivh ./*.rpm
警告：./postgresql96-9.6.20-2PGDG.rhel7.x86_64.rpm: 头V4 DSA/SHA1 Signature, 密钥 ID 442df0f8: NOKEY
准备中...                          ################################# [100%]
正在升级/安装...
   1:postgresql96-libs-9.6.20-2PGDG.rh################################# [ 33%]
   2:postgresql96-9.6.20-2PGDG.rhel7  ################################# [ 67%]
   3:postgresql96-server-9.6.20-2PGDG.################################# [100%]

2.初始化数据库

[root@localhost pgsql]# /usr/pgsql-9.6/bin/postgresql96-setup initdb
Initializing database ... OK

3.启动数据库服务

[root@localhost pgsql]# systemctl enable postgresql-9.6
Created symlink from /etc/systemd/system/multi-user.target.wants/postgresql-9.6.service to /usr/lib/systemd/system/postgresql-9.6.service.
[root@localhost pgsql]# systemctl start postgresql-9.6 
[root@localhost pgsql]# systemctl status postgresql-9.6
● postgresql-9.6.service - PostgreSQL 9.6 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-9.6.service; enabled; vendor preset: disabled)
   Active: active (running) since 三 2021-01-20 15:41:26 CST; 6s ago
     Docs: https://www.postgresql.org/docs/9.6/static/
  Process: 9636 ExecStartPre=/usr/pgsql-9.6/bin/postgresql96-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
 Main PID: 9642 (postmaster)
   CGroup: /system.slice/postgresql-9.6.service
           ├─9642 /usr/pgsql-9.6/bin/postmaster -D /var/lib/pgsql/9.6/data/
           ├─9644 postgres: logger process   
           ├─9646 postgres: checkpointer process   
           ├─9647 postgres: writer process   
           ├─9648 postgres: wal writer process   
           ├─9649 postgres: autovacuum launcher process   
           └─9650 postgres: stats collector process   

1月 20 15:41:26 cdh62-master systemd[1]: Starting PostgreSQL 9.6 database server...
1月 20 15:41:26 cdh62-master postmaster[9642]: < 2021-01-20 15:41:26.116 CST > 日志:  日志输出重定向到日志收集进程
1月 20 15:41:26 cdh62-master postmaster[9642]: < 2021-01-20 15:41:26.116 CST > 提示:  后续的日志输出将出现在目录 "pg_log"中.
1月 20 15:41:26 cdh62-master systemd[1]: Started PostgreSQL 9.6 database server.

4.配置监听指定IP

[root@localhost pgsql]# vi /var/lib/pgsql/9.6/data/postgresql.conf

5.配置访问信任

[root@localhost pgsql]# vi /var/lib/pgsql/9.6/data/pg_hba.conf

6.设置数据库密码

[root@localhost pgsql]# su postgres
bash-4.2$ ps
ps             psfaddtable    psfgettable    psfstriptable  psfxtable      psql           
bash-4.2$ psql -U postgres
psql (9.6.20)
输入 "help" 来获取帮助信息.

postgres=# alter user postgres with password 'cdh62';   
ALTER ROLE
postgres=# exit
postgres-# \q
bash-4.2$ exit
exit

7.重启数据库服务

[root@localhost pgsql]# systemctl restart postgresql-9.6
[root@localhost pgsql]# systemctl status postgresql-9.6 
● postgresql-9.6.service - PostgreSQL 9.6 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-9.6.service; enabled; vendor preset: disabled)
   Active: active (running) since 三 2021-01-20 15:53:13 CST; 6s ago
     Docs: https://www.postgresql.org/docs/9.6/static/
  Process: 9674 ExecStartPre=/usr/pgsql-9.6/bin/postgresql96-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
 Main PID: 9680 (postmaster)
   CGroup: /system.slice/postgresql-9.6.service
           ├─9680 /usr/pgsql-9.6/bin/postmaster -D /var/lib/pgsql/9.6/data/
           ├─9682 postgres: logger process   
           ├─9684 postgres: checkpointer process   
           ├─9685 postgres: writer process   
           ├─9686 postgres: wal writer process   
           ├─9687 postgres: autovacuum launcher process   
           └─9688 postgres: stats collector process   

1月 20 15:53:13 cdh62-master systemd[1]: Starting PostgreSQL 9.6 database server...
1月 20 15:53:13 cdh62-master postmaster[9680]: < 2021-01-20 15:53:13.679 CST > 日志:  日志输出重定向到日志收集进程
1月 20 15:53:13 cdh62-master postmaster[9680]: < 2021-01-20 15:53:13.679 CST > 提示:  后续的日志输出将出现在目录 "pg_log"中.
1月 20 15:53:13 cdh62-master systemd[1]: Started PostgreSQL 9.6 database server.

创建Cloudera Manager、Hive、Hue、Oozie等需要的表

### 创建角色及表的脚本如下
CREATE ROLE "hive" LOGIN PASSWORD 'hive';
CREATE DATABASE "metastore" WITH OWNER = "hive" ENCODING = 'UTF8';

CREATE ROLE "cm" LOGIN PASSWORD 'cm';
CREATE DATABASE "cm" WITH OWNER = "cm" ENCODING = 'UTF8';

CREATE ROLE "am" LOGIN PASSWORD 'am';
CREATE DATABASE "am" WITH OWNER = "am" ENCODING = 'UTF8';

CREATE ROLE "rm" LOGIN PASSWORD 'rm';
CREATE DATABASE "rm" WITH OWNER = "rm" ENCODING = 'UTF8';

CREATE ROLE "hue" LOGIN PASSWORD 'hue';
CREATE DATABASE "hue" WITH OWNER = "hue" ENCODING = 'UTF8';

CREATE ROLE "oozie" LOGIN PASSWORD 'oozie';
CREATE DATABASE "oozie" WITH OWNER = "oozie" ENCODING = 'UTF8';

### 执行如下
[root@localhost pgsql]# su postgres
bash-4.2$ psql -U postgres
psql (9.6.20)
输入 "help" 来获取帮助信息.

postgres=# CREATE ROLE "hive" LOGIN PASSWORD 'hive';
CREATE ROLE
postgres=# CREATE DATABASE "metastore" WITH OWNER = "hive" ENCODING = 'UTF8';
CREATE DATABASE
postgres=# CREATE ROLE "cm" LOGIN PASSWORD 'cm';
CREATE ROLE
postgres=# CREATE DATABASE "cm" WITH OWNER = "cm" ENCODING = 'UTF8';
CREATE DATABASE
postgres=# CREATE ROLE "am" LOGIN PASSWORD 'am';
CREATE ROLE
postgres=# CREATE DATABASE "am" WITH OWNER = "am" ENCODING = 'UTF8';
CREATE DATABASE
postgres=# CREATE ROLE "rm" LOGIN PASSWORD 'rm';
CREATE ROLE
postgres=# CREATE DATABASE "rm" WITH OWNER = "rm" ENCODING = 'UTF8';
CREATE DATABASE
postgres=# CREATE ROLE "hue" LOGIN PASSWORD 'hue';
CREATE ROLE
postgres=# CREATE DATABASE "hue" WITH OWNER = "hue" ENCODING = 'UTF8';
CREATE DATABASE
postgres=# CREATE ROLE "oozie" LOGIN PASSWORD 'oozie';
CREATE ROLE
postgres=# CREATE DATABASE "oozie" WITH OWNER = "oozie" ENCODING = 'UTF8';
CREATE DATABASE
postgres=# \q
bash-4.2$ exit
exit