GP无法启动，信息如下：

[gpadmin@gp-master gpseg-1]$ gpstart

20161223:09:32:09:002004 gpstart:gp-master:gpadmin-[INFO]:-Starting gpstart with args:

20161223:09:32:09:002004 gpstart:gp-master:gpadmin-[INFO]:-Gathering information and validating the environment...

20161223:09:32:09:002004 gpstart:gp-master:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.8.0 build 1'

20161223:09:32:09:002004 gpstart:gp-master:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150'

20161223:09:32:09:002004 gpstart:gp-master:gpadmin-[INFO]:-Starting Master instance in admin mode

20161223:09:32:11:002004 gpstart:gp-master:gpadmin-[CRITICAL]:-Failed to start Master instance in admin mode

20161223:09:32:11:002004 gpstart:gp-master:gpadmin-[CRITICAL]:-Error occurred: non-zero rc: 1

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

rc=1, stdout='waiting for server to start...... stopped waiting

', stderr='pg_ctl: PID file "/disk/master/gpseg-1/postmaster.pid" does not exist

pg_ctl: could not start server

Examine the log output.

'

这种情况一般是因为pg_hba.conf、环境变量设置的有问题，检查一遍后没有问题

于是看下pg_log下的startup.log如下：

2016-12-23 01:31:09.819803 GMT,,,p933,th440502048,,,,0,,,seg-1,,,,,"FATAL","55000","data directory ""/disk/master/gpseg-1"" has group or world access","Permissions should be u=rwx (0700).",,,,,,,"checkDataDir","postmaster.c",1763,

2016-12-23 01:32:09.643918 GMT,,,p2027,th-302590176,,,,0,,,seg-1,,,,,"FATAL","55000","data directory ""/disk/master/gpseg-1"" has group or world access","Permissions should be u=rwx (0700).",,,,,,,"checkDataDir","postmaster.c",1763,

按照错误来说/disk/master/gpseg-1数据目录权限有问题，应该设置成0700

[gpadmin@gp-master master]$ ls -l

total 4

drwxrwxrwx 17 gpadmin gpadmin 4096 Dec 23 09:49 gpseg-1

权限是777，改成0700

[gpadmin@gp-master master]$ chmod 0700 gpseg-1

[gpadmin@gp-master master]$ ls -l

total 4

drwx------ 17 gpadmin gpadmin 4096 Dec 23 09:49 gpseg-1

于是成功启动

很诧异777的权限是大于0700的，不应该是权限不足导致，难道GP是出于安全的考虑只允许gpadmin用户对数据目录进行操作?!

ITPub博客

Failed to start Master instance in admin mode

最新文章