그린플럼 기동 방식

[gpadmin@sachi Desktop]$ gpstart

20150526:09:50:59:002823 gpstart:sachi:gpadmin-[INFO]:-Starting gpstart with args:

20150526:09:50:59:002823 gpstart:sachi:gpadmin-[INFO]:-Gathering information and validating the environment...

20150526:09:51:00:002823 gpstart:sachi:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.5.1 build 1'

20150526:09:51:00:002823 gpstart:sachi:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150'

20150526:09:51:00:002823 gpstart:sachi:gpadmin-[INFO]:-Starting Master instance in admin mode

20150526:09:51:03:002823 gpstart:sachi:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information

20150526:09:51:03:002823 gpstart:sachi:gpadmin-[INFO]:-Obtaining Segment details from master...

20150526:09:51:04:002823 gpstart:sachi:gpadmin-[INFO]:-Setting new master era

20150526:09:51:04:002823 gpstart:sachi:gpadmin-[INFO]:-Master Started...

20150526:09:51:04:002823 gpstart:sachi:gpadmin-[INFO]:-Shutting down master

20150526:09:51:05:002823 gpstart:sachi:gpadmin-[INFO]:---------------------------

20150526:09:51:05:002823 gpstart:sachi:gpadmin-[INFO]:-Master instance parameters

20150526:09:51:05:002823 gpstart:sachi:gpadmin-[INFO]:---------------------------

20150526:09:51:05:002823 gpstart:sachi:gpadmin-[INFO]:-Database = template1

20150526:09:51:05:002823 gpstart:sachi:gpadmin-[INFO]:-Master Port = 5432

20150526:09:51:05:002823 gpstart:sachi:gpadmin-[INFO]:-Master directory = /gpmaster/gpsne-1

20150526:09:51:05:002823 gpstart:sachi:gpadmin-[INFO]:-Timeout = 600 seconds

20150526:09:51:05:002823 gpstart:sachi:gpadmin-[INFO]:-Master standby = Off

20150526:09:51:05:002823 gpstart:sachi:gpadmin-[INFO]:---------------------------------------

20150526:09:51:05:002823 gpstart:sachi:gpadmin-[INFO]:-Segment instances that will be started

20150526:09:51:05:002823 gpstart:sachi:gpadmin-[INFO]:---------------------------------------

20150526:09:51:05:002823 gpstart:sachi:gpadmin-[INFO]:- Host Datadir Port

20150526:09:51:05:002823 gpstart:sachi:gpadmin-[INFO]:- sachi /gpdata1/gpsne0 50000

20150526:09:51:05:002823 gpstart:sachi:gpadmin-[INFO]:- sachi /gpdata2/gpsne1 50001

 

Continue with Greenplum instance startup Yy|Nn (default=N):

> y

20150526:09:51:11:002823 gpstart:sachi:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...

.....

20150526:09:51:16:002823 gpstart:sachi:gpadmin-[INFO]:-Process results...

20150526:09:51:16:002823 gpstart:sachi:gpadmin-[INFO]:-----------------------------------------------------

20150526:09:51:16:002823 gpstart:sachi:gpadmin-[INFO]:- Successful segment starts = 2

20150526:09:51:16:002823 gpstart:sachi:gpadmin-[INFO]:- Failed segment starts = 0

20150526:09:51:16:002823 gpstart:sachi:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0

20150526:09:51:16:002823 gpstart:sachi:gpadmin-[INFO]:-----------------------------------------------------

20150526:09:51:16:002823 gpstart:sachi:gpadmin-[INFO]:-

20150526:09:51:16:002823 gpstart:sachi:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances

20150526:09:51:16:002823 gpstart:sachi:gpadmin-[INFO]:-----------------------------------------------------

20150526:09:51:16:002823 gpstart:sachi:gpadmin-[INFO]:-Starting Master instance sachi directory /gpmaster/gpsne-1

20150526:09:51:18:002823 gpstart:sachi:gpadmin-[INFO]:-Command pg_ctl reports Master sachi instance active

20150526:09:51:19:002823 gpstart:sachi:gpadmin-[INFO]:-No standby master configured. skipping...

20150526:09:51:19:002823 gpstart:sachi:gpadmin-[INFO]:-Database successfully started

[gpadmin@sachi Desktop]$

 

그린플럼에 경우는 오라클과 상당히 다른 점을 가진다.

오라클의 경우 전용 프로그램인 SQL*PLUS라는 툴을 가지고 데이터 베이스를 기동하지만 그린플럼의 경우 일반 유저가 커맨드 상에서도

기동이 가능하다는 점이다. 이 점으로 보았을 때 OS의 루트로도 기동이 되지 않을까 싶어 테스트를 해보았다.

 

[root@sachi /]# gpstart

20150526:10:00:36:003374 gpstart:sachi:root-[INFO]:-Starting gpstart with args:

20150526:10:00:36:003374 gpstart:sachi:root-[INFO]:-Gathering information and validating the environment...

20150526:10:00:36:003374 gpstart:sachi:root-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.5.1 build 1'

20150526:10:00:36:003374 gpstart:sachi:root-[INFO]:-Greenplum Catalog Version: '201310150'

20150526:10:00:36:003374 gpstart:sachi:root-[INFO]:-Starting Master instance in admin mode

20150526:10:00:36:003374 gpstart:sachi:root-[CRITICAL]:-Failed to start Master instance in admin mode

20150526:10:00:36:003374 gpstart:sachi:root-[CRITICAL]:-Error occurred: non-zero rc: 1

Command was: 'env GPSESSID=0000000000 GPERA=None $GPHOME/bin/pg_ctl -D /gpmaster/gpsne-1 -l /gpmaster/gpsne-1/pg_log/startup.log -w -t 600 -o " -p 5432 -b 1 -z 0 --silent-mode=true -i -M master -C -1 -x 0 -c gp_role=utility " start'

rc=1, stdout='', stderr='pg_ctl: cannot be run as root

Please log in (using, e.g., "su") as the (unprivileged) user that will

own the server process.

'

[root@sachi /]#

 

결과는 ownership만 있다면 root 조차도 기동이 가능할 것만 같다. 물론 오라클과 동일하게 결과적으로 봤을때는 DB 기동이 안됐지만

개인적으로는 그린플럼이 OS관리자에게 매우 보안성이 취약한 DB가 아닌가 하는 생각이 든다.