本篇内容介绍了“greenplum4.3.33的安装步骤”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！2020.01.19查看日志报错：pg_ctl报错日志：FATAL: could not create semaphores: No space left on device修改vi /etc/sysctl.conf更改如下行为：kernel.sem = 50100 128256000 50100 2560修改结果：[root@demo02 ~]# ipcs -ls—— Semaphore Limits ——–max number of arrays = 2560max semaphores per array = 50100max semaphores system wide = 12免费云主机域名8256000max ops per semop call = 50100semaphore max value = 32767处理过程：/oradata/gp/gpdata/mkdir -p /oradata/gp/gpdata/gpdatam1mkdir -p /oradata/gp/gpdata/gpdatam2mkdir -p /oradata/gp/gpdata/gpdatap1mkdir -p /oradata/gp/gpdata/gpdatap2mkdir -p /oradata/gp/gpdata/gpmastergpssh -f /home/gpadmin/conf/hostlist/oradata/gp/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_configgpinitsystem -c /oradata/gp/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config -h /home/gpadmin/conf/hostlist[gpadmin@demo02 gpdata]$ gpinitsystem -c /oradata/gp/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config -h /home/gpadmin/conf/hostlist20200119:22:56:18:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Checking configuration parameters, please wait…20200119:22:56:18:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Reading Greenplum configuration file /oradata/gp/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config20200119:22:56:18:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Locale has not been set in /oradata/gp/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config, will set to default value20200119:22:56:18:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Locale set to en_US.utf820200119:22:56:19:022378 gpinitsystem:demo02:gpadmin-[INFO]:-No DATABASE_NAME set, will exit following template1 updates20200119:22:56:19:022378 gpinitsystem:demo02:gpadmin-[WARN]:-ENCODING variable not set, will set to default UTF-820200119:22:56:19:022378 gpinitsystem:demo02:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 25020200119:22:56:19:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Checking configuration parameters, Completed20200119:22:56:19:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Commencing multi-home checks, please wait…..20200119:22:56:26:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Configuring build for standard array20200119:22:56:26:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Commencing multi-home checks, Completed20200119:22:56:26:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Building primary segment instance array, please wait…….20200119:22:57:06:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Building group mirror array type , please wait…….20200119:22:57:29:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Checking Master host20200119:22:57:29:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Checking new segment hosts, please wait………..20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Checking new segment hosts, Completed20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Greenplum Database Creation Parameters20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:—————————————20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master Configuration20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:—————————————20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master instance name = Greenplum20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master hostname = demo0220200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master port = 234520200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master instance dir = /oradata/gp/gpdata/gpmaster/gpseg-120200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master LOCALE = en_US.utf820200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Greenplum segment prefix = gpseg20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master Database =20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master connections = 25020200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master buffers = 128000kB20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Segment connections = 75020200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Segment buffers = 128000kB20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Checkpoint segments = 820200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Encoding = UTF-820200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Postgres param file = Off20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Initdb to be used = /oradata/gp/greenplum-db/./bin/initdb20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-GP_LIBRARY_PATH is = /oradata/gp/greenplum-db/./lib20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Ulimit check = Passed20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Array host connect type = Single hostname per node20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master IP address [1] = ::120200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master IP address [2] = 10.138.231.20120200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master IP address [3] = 172.32.16.220200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master IP address [4] = 172.32.32.220200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master IP address [5] = fe80::250:56ff:fe8c:20d220200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master IP address [6] = fe80::250:56ff:fe8c:237520200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master IP address [7] = fe80::250:56ff:fe8c:a09120200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master IP address [8] = fe80::250:56ff:fe8c:c8120200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master IP address [9] = fe80::250:56ff:fe8c:d58420200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Standby Master = Not Configured20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Primary segment # = 220200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Total Database segments = 420200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Trusted shell = ssh20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Number segment hosts = 220200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Mirror port base = 4300020200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Replicaton port base = 3400020200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Mirror replicaton port base= 4400020200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Mirror segment # = 220200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Mirroring config = ON20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Mirroring type = Group20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:—————————————-20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Greenplum Primary Segment Configuration20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:—————————————-20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-demo02 /oradata/gp/gpdata/gpdatap1/gpseg0 33000 2 0 3400020200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-demo02 /oradata/gp/gpdata/gpdatap2/gpseg1 33001 3 1 3400120200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-demo01 /oradata/gp/gpdata/gpdatap1/gpseg2 33000 4 2 3400020200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-demo01 /oradata/gp/gpdata/gpdatap2/gpseg3 33001 5 3 3400120200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:—————————————20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Greenplum Mirror Segment Configuration20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:—————————————20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-demo01 /oradata/gp/gpdata/gpdatam1/gpseg0 43000 6 0 4400020200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-demo01 /oradata/gp/gpdata/gpdatam2/gpseg1 43001 7 1 4400120200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-demo02 /oradata/gp/gpdata/gpdatam1/gpseg2 43000 8 2 4400020200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-demo02 /oradata/gp/gpdata/gpdatam2/gpseg3 43001 9 3 44001Continue with Greenplum creation Yy/Nn>y20200119:23:03:32:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Building the Master instance database, please wait…20200119:23:03:45:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Starting the Master in admin mode20200119:23:04:45:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Commencing parallel build of primary segment instances20200119:23:04:45:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Spawning parallel processes batch [1], please wait…….20200119:23:04:45:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………..20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:————————————————20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Parallel process exit status20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:————————————————20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Total processes marked as completed = 420200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Total processes marked as killed = 020200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Total processes marked as failed = 020200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:————————————————20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Commencing parallel build of mirror segment instances20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Spawning parallel processes batch [1], please wait…….20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………….20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:————————————————20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Parallel process exit status20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:————————————————20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Total processes marked as completed = 420200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Total processes marked as killed = 020200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Total processes marked as failed = 020200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:————————————————20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Deleting distributed backout files20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Removing back out file20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:-No errors generated from parallel processes20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode20200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-Starting gpstop with args: -a -l /home/gpadmin/gpAdminLogs -i -m -d /oradata/gp/gpdata/gpmaster/gpseg-120200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-Gathering information and validating the environment…20200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information20200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-Obtaining Segment details from master…20200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-Greenplum Version: ‘postgres (Greenplum Database) 4.3.33.4 build 1’20200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-There are 0 connections to the database20200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=’immediate’20200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-Master host=demo0220200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=immediate20200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-Master segment instance directory=/oradata/gp/gpdata/gpmaster/gpseg-120200119:23:22:23:004847 gpstop:demo02:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process20200119:23:22:23:004847 gpstop:demo02:gpadmin-[INFO]:-Terminating processes for segment /oradata/gp/gpdata/gpmaster/gpseg-120200119:23:22:23:004874 gpstart:demo02:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs -d /oradata/gp/gpdata/gpmaster/gpseg-120200119:23:22:23:004874 gpstart:demo02:gpadmin-[INFO]:-Gathering information and validating the environment…20200119:23:22:23:004874 gpstart:demo02:gpadmin-[INFO]:-Greenplum Binary Version: ‘postgres (Greenplum Database) 4.3.33.4 build 1’20200119:23:22:23:004874 gpstart:demo02:gpadmin-[INFO]:-Greenplum Catalog Version: ‘201310150’20200119:23:22:23:004874 gpstart:demo02:gpadmin-[INFO]:-Starting Master instance in admin mode20200119:23:22:24:004874 gpstart:demo02:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information20200119:23:22:24:004874 gpstart:demo02:gpadmin-[INFO]:-Obtaining Segment details from master…20200119:23:22:24:004874 gpstart:demo02:gpadmin-[INFO]:-Setting new master era20200119:23:22:24:004874 gpstart:demo02:gpadmin-[INFO]:-Master Started…20200119:23:22:24:004874 gpstart:demo02:gpadmin-[INFO]:-Shutting down master20200119:23:22:26:004874 gpstart:demo02:gpadmin-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait……………….20200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:-Process results…20200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:—————————————————–20200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:- Successful segment starts = 820200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:- Failed segment starts = 020200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 020200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:—————————————————–20200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:-20200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:-Successfully started 8 of 8 segment instances20200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:—————————————————–20200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:-Starting Master instance demo02 directory /oradata/gp/gpdata/gpmaster/gpseg-120200119:23:22:43:004874 gpstart:demo02:gpadmin-[INFO]:-Command pg_ctl reports Master demo02 instance active20200119:23:22:43:004874 gpstart:demo02:gpadmin-[INFO]:-No standby master configured. skipping…20200119:23:22:43:004874 gpstart:demo02:gpadmin-[INFO]:-Database successfully started20200119:23:22:46:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode20200119:23:22:46:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Loading gp_toolkit…20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Scanning utility log file for any warning messages20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[WARN]:-*******************************************************20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[WARN]:-Scan of log file indicates that some warnings or errors20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[WARN]:-were generated during the array creation20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Please review contents of log file20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20200119.log20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-To determine level of criticality20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-These messages could be from a previous run of the utility20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-that was called today!20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[WARN]:-*******************************************************20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Greenplum Database instance successfully created20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:——————————————————-20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-To complete the environment configuration, please20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-update gpadmin .bashrc file with the following20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-2. Add “export MASTER_DATA_DIRECTORY=/oradata/gp/gpdata/gpmaster/gpseg-1″20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:- to access the Greenplum scripts for this instance:20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:- or, use -d /oradata/gp/gpdata/gpmaster/gpseg-1 option for the Greenplum scripts20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:- Example gpstate -d /oradata/gp/gpdata/gpmaster/gpseg-120200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20200119.log20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-To initialize a Standby Master Segment for this Greenplum instance20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Review options for gpinitstandby20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:——————————————————-20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-The Master /oradata/gp/gpdata/gpmaster/gpseg-1/pg_hba.conf post gpinitsystem20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-has been configured to allow all hosts within this new20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-new array must be explicitly added to this file20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-located in the /oradata/gp/greenplum-db/./docs directory20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:——————————————————-初始化完成后：[gpadmin@demo02 gpseg-1]$ psql -h 10.138.231.201 -d postgres -p 2345“greenplum4.3.33的安装步骤”的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注百云网站，小编将为大家输出更多高质量的实用文章！
Redis中内部数据结构sds的作用是什么，很多新手对此不是很清楚，为了帮助大家解决这个难题，下面小编将为大家详细讲解，有这方面需求的人可以来学习下，希望你能有所收获。sds的数据结构定义我们知道，在C语言中，字符串是以’’字符结尾（NULL结束符）的字符数组…
免责声明：本站发布的图片视频文字，以转载和分享为主，文章观点不代表本站立场，本站不承担相关法律责任；如果涉及侵权请联系邮箱：360163164@qq.com举报，并提供相关证据，经查实将立刻删除涉嫌侵权内容。
微信扫一扫 
