標(biāo)簽(空格分隔): GreenPlum
在配置好GreenPlum過程中,需要注意一下幾點(diǎn):
- 找好安裝包
- 安裝依賴,Gun版本需要注意
- 詳細(xì)安裝步驟參考Greenplum安裝介紹
自己是電腦虛擬機(jī)安裝的中間出現(xiàn)很多報(bào)錯(cuò),度娘加經(jīng)驗(yàn)解決。最后啟動(dòng)還是報(bào)錯(cuò),發(fā)現(xiàn)是資源不足,所以關(guān)閉了mirror,減少了segment。然后啟動(dòng)還是報(bào)錯(cuò):
> > 20190122:20:23:14:003437 gpstart:mpp01:gpadmin-[INFO]:-Commencing parallel segment instance
> startup, please wait...
> ...
> 20190122:20:23:17:003437 gpstart:mpp01:gpadmin-[INFO]:-Process results...
> 20190122:20:23:17:003437 gpstart:mpp01:gpadmin-[INFO]:-----------------------------------------------------
> 20190122:20:23:17:003437 gpstart:mpp01:gpadmin-[INFO]:- Successful segment starts =
> 3
> 20190122:20:23:17:003437 gpstart:mpp01:gpadmin-[INFO]:- Failed segment starts = 0
> 20190122:20:23:17:003437 gpstart:mpp01:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
> 20190122:20:23:17:003437 gpstart:mpp01:gpadmin-[INFO]:-----------------------------------------------------
> 20190122:20:23:17:003437 gpstart:mpp01:gpadmin-[INFO]:-Successfully started 3 of 3 segment
> instances
> 20190122:20:23:17:003437 gpstart:mpp01:gpadmin-[INFO]:-----------------------------------------------------
> 20190122:20:23:17:003437 gpstart:mpp01:gpadmin-[INFO]:-Starting Master instance mpp01 directory /opt/greenplum/data/master/gpseg-1
> 20190122:20:23:18:003437 gpstart:mpp01:gpadmin-[INFO]:-Command pg_ctl reports Master mpp01 instance active
> 20190122:20:23:19:003437 gpstart:mpp01:gpadmin-[WARNING]:-FATAL: DTM initialization: failure during startup recovery, retry failed,
> check segment status (cdbtm.c:1517)
> 20190122:20:23:19:003437 gpstart:mpp01:gpadmin-[INFO]:-No standby master configured. skipping...
> 20190122:20:23:19:003437 gpstart:mpp01:gpadmin-[INFO]:-Check status of database with gpstate utility
查看日志沒有找到什么原因,后臺度娘發(fā)現(xiàn)了,原來是防火墻沒有關(guān)閉。那么就來關(guān)閉防火墻:
/etc/init.d/iptables stop
[root@mpp03 ~]# /etc/init.d/iptables stop
iptables: Setting chains to policy ACCEPT: filter [ OK ]
iptables: Flushing firewall rules: [ OK ]
iptables: Unloading modules: [ OK ]
在3臺機(jī)器上都關(guān)閉防火墻操作,然后啟動(dòng)
gpstart
20190122:20:28:01:004200 gpstart:mpp01:gpadmin-[INFO]:-Process results...
20190122:20:28:01:004200 gpstart:mpp01:gpadmin-[INFO]:-----------------------------------------------------
20190122:20:28:01:004200 gpstart:mpp01:gpadmin-[INFO]:- Successful segment starts = 3
20190122:20:28:01:004200 gpstart:mpp01:gpadmin-[INFO]:- Failed segment starts = 0
20190122:20:28:01:004200 gpstart:mpp01:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20190122:20:28:01:004200 gpstart:mpp01:gpadmin-[INFO]:-----------------------------------------------------
20190122:20:28:01:004200 gpstart:mpp01:gpadmin-[INFO]:-Successfully started 3 of 3 segment instances
20190122:20:28:01:004200 gpstart:mpp01:gpadmin-[INFO]:-----------------------------------------------------
20190122:20:28:01:004200 gpstart:mpp01:gpadmin-[INFO]:-Starting Master instance mpp01 directory /opt/greenplum/data/master/gpseg-1
20190122:20:28:02:004200 gpstart:mpp01:gpadmin-[INFO]:-Command pg_ctl reports Master mpp01 instance active
20190122:20:28:02:004200 gpstart:mpp01:gpadmin-[INFO]:-No standby master configured. skipping...
20190122:20:28:02:004200 gpstart:mpp01:gpadmin-[INFO]:-Database successfully started
啟動(dòng)成功!
psql
[gpadmin@mpp01 ~]$ psql
psql (8.3.23)
Type "help" for help.
gp_sydb=#
啟動(dòng)成功了,開始下面的學(xué)習(xí)吧