導入VWmare鏡像后狞山,由于之前安裝時啟動了網(wǎng)路纸泡,所以IP地址可能和本地網(wǎng)卡地址不符陈症,請按照以下步驟修改:
步驟一:確認網(wǎng)絡蔼水。
在Linux操作系統(tǒng)上,通過ifconfig來查看二張網(wǎng)卡是否都正常啟動录肯,具體如下:
[root@db1 ~]# ifconfig
enp0s3: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 192.168.28.129 netmask 255.255.255.0 broadcast 192.168.56.255
inet6 fe80::ac2f:dc4f:edfe:1d57 prefixlen 64 scopeid 0x20<link>
ether 08:00:27:0f:78:e3 txqueuelen 1000 (Ethernet)
RX packets 519 bytes 48509 (47.3 KiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 178 bytes 52937 (51.6 KiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
enp0s8: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 192.168.220.129 netmask 255.255.255.0 broadcast 10.0.3.255
inet6 fe80::bedc:2040:4b9:23ed prefixlen 64 scopeid 0x20<link>
ether 08:00:27:45:8d:f0 txqueuelen 1000 (Ethernet)
RX packets 72 bytes 10702 (10.4 KiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 124 bytes 11664 (11.3 KiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
……………………………..
virbr0: flags=4099<UP,BROADCAST,MULTICAST> mtu 1500
inet 192.168.122.1 netmask 255.255.255.0 broadcast 192.168.122.255
ether 52:54:00:05:11:90 txqueuelen 1000 (Ethernet)
RX packets 0 bytes 0 (0.0 B)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 0 bytes 0 (0.0 B)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
記錄下第二個網(wǎng)卡的網(wǎng)址趴腋,例如本案例中的 192.168.220.129 。
步驟二:修改數(shù)據(jù)庫的pg_hba.conf文件论咏。
在GS_HOME中查找pg_hba.conf文件优炬,本實驗中數(shù)據(jù)庫GS_HOME設置的為/gaussdb/data/db1,實際操作中GS_HOME地址可以查看安裝時的配置文件:
<PARAM name="dataNode1" value="/gaussdb/data/db1"/>厅贪。
cd /gaussdb/data/db1
vi pg_hba.conf
輸入“:90”找到對應位置蠢护,然后輸入“i”切換到INSERT模式,將以下“host all all 192.168.119.131/32 trust”中的IP地址換為記錄下的第二個網(wǎng)卡的地址(請根據(jù)實際情況修改)养涮,修改后按下“ECS”鍵葵硕,退出INSERT模式,輸入“:wq”后回車保存单寂。
修改前:
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all 192.168.119.131/32 trust
# IPv6 local connections:
host all all ::1/128 trust
修改后:
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all 192.168.220.129/32 trust
# IPv6 local connections:
host all all ::1/128 trust
使用omm用戶登陸,使用gs_ctl將策略生效吐辙。
su - omm
gs_ctl reload -D /gaussdb/data/db1/
返回結果為:
[2020-07-23 15:39:55.398][71828][][gs_ctl]: gs_ctl reload ,datadir is -D "/gaussdb/data/db1"
server signaled
注:如果之前沒有啟動過數(shù)據(jù)庫宣决,返回結果如下,繼續(xù)操作即可:
[2021-03-18 15:37:57.305][3093][][gs_ctl]: gs_ctl reload ,datadir is /gaussdb/data/db1
[2021-03-18 15:37:57.306][3093][][gs_ctl]: PID file“/gaussdb/data/db1/postmaster.pid” dose not exist
[2021-03-18 15:37:57.306][3093][][gs_ctl]: Is server running?
步驟三:修改數(shù)據(jù)庫偵聽地址昏苏。
在GS_HOME中尊沸,本實驗中數(shù)據(jù)庫GS_HOME設置的為/gaussdb/data/db1。
cd /gaussdb/data/db1
vi postgresql.conf
輸入“:60”找到對應位置贤惯,然后輸入“i”切換到INSERT模式洼专,將listen_addresses的值修改成為第二個網(wǎng)卡的地址(請根據(jù)實際情況修改),修改后按下“ECS”鍵孵构,退出INSERT模式屁商,輸入“:wq”后回車保存。
修改前:
listen_addresses = '192.168.119.131' # what IP address(es) to listen on;
修改后:
listen_addresses = '192.168.220.129' # what IP address(es) to listen on;
修改完成后重啟數(shù)據(jù)庫生效(-D后面的數(shù)據(jù)庫默認路徑颈墅,需要根據(jù)實際情況進行修改)蜡镶。
gs_ctl restart -D /gaussdb/data/db1/
步驟四:啟動數(shù)據(jù)庫成功雾袱。
[omm@db1 db1]$ gs_om -t start
Starting cluster.
=========================================
[SUCCESS] db1:
[2021-04-01 15:09:02.959][4472][][gs_ctl]: gs_ctl started,datadir is /gaussdb/data/db1
[2021-04-01 15:09:02.966][4472][][gs_ctl]: another server might be running; Please use the restart command
=========================================
Successfully started.