greenplum单机版
来源：互联网 发布：樱井ともか樱井知香 编辑：程序博客网 时间：2024/05/02 04:17
环境准备：
LINUX操作系统 : Red Hat Enterprise Linux Server release 6.1 (Santiago)
greenplum 软件: greenplum-db-4.0.4.0-build-3-SingleNodeEdition-RHEL5-x86_64.bin
操作步骤：
[root@RedHat6 soft]# groupadd longtop
[root@RedHat6 soft]# groupadd gpadmin
[root@RedHat6 soft]# useradd -g gpadmin longtop
[root@RedHat6 soft]# passwd longtop
[root@RedHat6 soft]# ls -l
总用量 109824
-rwxr-xr-x. 1 longtop gpadmin 56775022 12月 1 2010 greenplum-db-4.0.4.0-build-3-SingleNodeEdition-RHEL5-x86_64.bin
-rw-r--r--. 1 longtop gpadmin 55669551 6月 25 19:41 greenplum-db-4.0.4.0-build-3-SingleNodeEdition-RHEL5-x86_64.zip
-r--r--r--. 1 longtop gpadmin 6789 12月 1 2010 README_INSTALL
[root@RedHat6 soft]# ./greenplum-db-4.0.4.0-build-3-SingleNodeEdition-RHEL5-x86_64.bin
…………
中间两次 输入 y
-----安装完成---
在 /grplum/目录手工增加hostfile 文件
下面是配置一个数据库
[root@RedHat6 grplum]# ls -l
总用量 20
-rw-r--r--. 1 longtop gpadmin 20 6月 25 22:10 hostfile
drwxr-xr-x. 2 longtop gpadmin 4096 6月 25 22:12 soft
[root@RedHat6 grplum]# hostname
RedHat6.localdomain
[root@RedHat6 grplum]# cat hostfile
RedHat6.localdomain
[root@RedHat6 grplum]# pwd
/grplum
[root@RedHat6 grplum]#
切换到longtop用户操作:
[longtop@RedHat6 grplum]$ cp /usr/local/greenplum-db/docs/cli_help/gp_init_config_example /grplum
[longtop@RedHat6 grplum]$ chmod +w gp_init_config_example
[longtop@RedHat6 grplum]$ vi gp_init_config_example
declare -a DATA_DIRECTORY=(/grplum) --修改
MASTER_HOSTNAME=RedHat6.localdomain --修改
MASTER_DIRECTORY=/grplum --修改
DATABASE_NAME=chx --修改
MACHINE_LIST_FILE=/grplum/hostfile --修改
[longtop@RedHat6 grplum]$ gpssh-exkeys -f hostfile
[STEP 1 of 5] create local ID and authorize on local host
[STEP 2 of 5] keyscan all hosts and update known_hosts file
[STEP 3 of 5] authorize current user on remote hosts
[STEP 4 of 5] determine common authentication file content
[STEP 5 of 5] copy authentication files to all remote hosts
[INFO] completed successfully
[longtop@RedHat6 grplum]$ gpinitsystem -c gp_init_config_example
20150625:22:23:53:gpinitsystem:RedHat6:longtop-[INFO]:-Checking configuration parameters, please wait...
20150625:22:23:54:gpinitsystem:RedHat6:longtop-[INFO]:-Reading Greenplum configuration file gp_init_config_example
20150625:22:23:54:gpinitsystem:RedHat6:longtop-[INFO]:-Locale has not been set in gp_init_config_example, will set to default value
20150625:22:23:54:gpinitsystem:RedHat6:longtop-[INFO]:-Locale set to en_US.utf8
20150625:22:23:54:gpinitsystem:RedHat6:longtop-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 25
20150625:22:23:54:gpinitsystem:RedHat6:longtop-[INFO]:-Detected a single host GPDB array build, reducing value of BATCH_DEFAULT from 60 to 4
20150625:22:23:54:gpinitsystem:RedHat6:longtop-[INFO]:-Checking configuration parameters, Completed
20150625:22:23:54:gpinitsystem:RedHat6:longtop-[INFO]:-Commencing multi-home checks, please wait...
.
20150625:22:23:55:gpinitsystem:RedHat6:longtop-[INFO]:-Configuring build for standard array
20150625:22:23:55:gpinitsystem:RedHat6:longtop-[INFO]:-Commencing multi-home checks, Completed
20150625:22:23:55:gpinitsystem:RedHat6:longtop-[INFO]:-Building primary segment instance array, please wait...
.
20150625:22:23:56:gpinitsystem:RedHat6:longtop-[INFO]:-Checking Master host
20150625:22:23:56:gpinitsystem:RedHat6:longtop-[INFO]:-Checking new segment hosts, please wait...
.
20150625:22:23:59:gpinitsystem:RedHat6:longtop-[INFO]:-Checking new segment hosts, Completed
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Greenplum Database Creation Parameters
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:---------------------------------------
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Master Configuration
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:---------------------------------------
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Master instance name = Greenplum
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Master hostname = RedHat6.localdomain
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Master port = 5432
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Master instance dir = /grplum/gpseg-1
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Master LOCALE = en_US.utf8
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Greenplum segment prefix = gpseg
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Master Database = chx
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Master connections = 25
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Master buffers = 128000kB
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Segment connections = 125
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Segment buffers = 128000kB
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Checkpoint segments = 8
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Encoding = UNICODE
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Postgres param file = Off
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Initdb to be used = /usr/local/greenplum-db/./bin/initdb
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-GP_LIBRARY_PATH is = /usr/local/greenplum-db/./lib
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Ulimit check = Passed
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Array host connect type = Single hostname per node
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Master IP address [1] = 192.168.2.100
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Master only build = Off
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Standby Master = Not Configured
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Primary segment # = 1
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Total Database segments = 1
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Trusted shell = ssh
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Number segment hosts = 1
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Mirroring config = OFF
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:----------------------------------------
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:-Greenplum Primary Segment Configuration
20150625:22:24:00:gpinitsystem:RedHat6:longtop-[INFO]:----------------------------------------
20150625:22:24:01:gpinitsystem:RedHat6:longtop-[INFO]:-RedHat6.localdomain /grplum/gpseg0 40000 2 0
Continue with Greenplum creation Yy/Nn>
y
20150625:22:24:28:gpinitsystem:RedHat6:longtop-[INFO]:-Building the Master instance database, please wait...
20150625:22:27:09:gpinitsystem:RedHat6:longtop-[INFO]:-Starting the Master in admin mode
20150625:22:27:21:gpinitsystem:RedHat6:longtop-[INFO]:-Commencing parallel build of primary segment instances
20150625:22:27:21:gpinitsystem:RedHat6:longtop-[INFO]:-Spawning parallel processes batch [1], please wait...
.
20150625:22:27:21:gpinitsystem:RedHat6:longtop-[INFO]:-Waiting for parallel processes batch [1], please wait...
...........................................................................................................................................
20150625:22:30:03:gpinitsystem:RedHat6:longtop-[INFO]:------------------------------------------------
20150625:22:30:03:gpinitsystem:RedHat6:longtop-[INFO]:-Parallel process exit status
20150625:22:30:03:gpinitsystem:RedHat6:longtop-[INFO]:------------------------------------------------
20150625:22:30:03:gpinitsystem:RedHat6:longtop-[INFO]:-Total processes marked as completed = 1
20150625:22:30:03:gpinitsystem:RedHat6:longtop-[INFO]:-Total processes marked as killed = 0
20150625:22:30:03:gpinitsystem:RedHat6:longtop-[INFO]:-Total processes marked as failed = 0
20150625:22:30:03:gpinitsystem:RedHat6:longtop-[INFO]:------------------------------------------------
20150625:22:30:04:gpinitsystem:RedHat6:longtop-[INFO]:-Deleting distributed backout files
20150625:22:30:04:gpinitsystem:RedHat6:longtop-[INFO]:-Removing back out file
20150625:22:30:04:gpinitsystem:RedHat6:longtop-[INFO]:-No errors generated from parallel processes
20150625:22:30:04:gpinitsystem:RedHat6:longtop-[INFO]:-Restarting the Greenplum instance in production mode
20150625:22:30:04:gpstop:RedHat6:longtop-[INFO]:-Starting gpstop with args: -a -i -m -d /grplum/gpseg-1
20150625:22:30:04:gpstop:RedHat6:longtop-[INFO]:-Gathering information and validating the environment...
20150625:22:30:04:gpstop:RedHat6:longtop-[INFO]:-Obtaining Greenplum Master catalog information
20150625:22:30:04:gpstop:RedHat6:longtop-[INFO]:-Obtaining Segment details from master...
20150625:22:30:05:gpstop:RedHat6:longtop-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 4.0.4.0 build 3 Single-Node Edition'
20150625:22:30:05:gpstop:RedHat6:longtop-[INFO]:-There are 0 connections to the database
20150625:22:30:05:gpstop:RedHat6:longtop-[INFO]:-Commencing Master instance shutdown with mode='immediate'
20150625:22:30:05:gpstop:RedHat6:longtop-[INFO]:-Master host=RedHat6.localdomain
20150625:22:30:05:gpstop:RedHat6:longtop-[INFO]:-Commencing Master instance shutdown with mode=immediate
20150625:22:30:05:gpstop:RedHat6:longtop-[INFO]:-Master segment instance directory=/grplum/gpseg-1
20150625:22:30:07:gpstart:RedHat6:longtop-[INFO]:-Starting gpstart with args: -a -d /grplum/gpseg-1
20150625:22:30:07:gpstart:RedHat6:longtop-[INFO]:-Gathering information and validating the environment...
20150625:22:30:07:gpstart:RedHat6:longtop-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.0.4.0 build 3 Single-Node Edition'
20150625:22:30:07:gpstart:RedHat6:longtop-[INFO]:-Greenplum Catalog Version: '201005134'
20150625:22:30:07:gpstart:RedHat6:longtop-[INFO]:-Starting Master instance in admin mode
20150625:22:30:09:gpstart:RedHat6:longtop-[INFO]:-Obtaining Greenplum Master catalog information
20150625:22:30:09:gpstart:RedHat6:longtop-[INFO]:-Obtaining Segment details from master...
20150625:22:30:09:gpstart:RedHat6:longtop-[INFO]:-Master Started...
20150625:22:30:09:gpstart:RedHat6:longtop-[INFO]:-Shutting down master
20150625:22:30:11:gpstart:RedHat6:longtop-[INFO]:-No standby master configured. skipping...
20150625:22:30:11:gpstart:RedHat6:longtop-[INFO]:-Commencing parallel segment instance startup, please wait...
..
20150625:22:30:13:gpstart:RedHat6:longtop-[INFO]:-Process results...
20150625:22:30:13:gpstart:RedHat6:longtop-[INFO]:-----------------------------------------------------
20150625:22:30:13:gpstart:RedHat6:longtop-[INFO]:- Successful segment starts = 1
20150625:22:30:13:gpstart:RedHat6:longtop-[INFO]:- Failed segment starts = 0
20150625:22:30:13:gpstart:RedHat6:longtop-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20150625:22:30:13:gpstart:RedHat6:longtop-[INFO]:-----------------------------------------------------
20150625:22:30:13:gpstart:RedHat6:longtop-[INFO]:-
20150625:22:30:13:gpstart:RedHat6:longtop-[INFO]:-Successfully started 1 of 1 segment instances
20150625:22:30:13:gpstart:RedHat6:longtop-[INFO]:-----------------------------------------------------
20150625:22:30:13:gpstart:RedHat6:longtop-[INFO]:-Starting Master instance RedHat6.localdomain directory /grplum/gpseg-1
20150625:22:30:15:gpstart:RedHat6:longtop-[INFO]:-Command pg_ctl reports Master RedHat6.localdomain instance active
20150625:22:30:16:gpstart:RedHat6:longtop-[INFO]:-Database successfully started with no errors reported
20150625:22:30:16:gpinitsystem:RedHat6:longtop-[INFO]:-Completed restart of Greenplum instance in production mode
20150625:22:30:16:gpinitsystem:RedHat6:longtop-[INFO]:-Loading gp_toolkit...
ALTER ROLE
20150625:22:31:03:gpinitsystem:RedHat6:longtop-[INFO]:-Scanning utility log file for any warning messages
20150625:22:31:03:gpinitsystem:RedHat6:longtop-[WARN]:-*******************************************************
20150625:22:31:03:gpinitsystem:RedHat6:longtop-[WARN]:-Scan of log file indicates that some warnings or errors
20150625:22:31:03:gpinitsystem:RedHat6:longtop-[WARN]:-were generated during the array creation
20150625:22:31:03:gpinitsystem:RedHat6:longtop-[INFO]:-Please review contents of log file
20150625:22:31:03:gpinitsystem:RedHat6:longtop-[INFO]:-/home/longtop/gpAdminLogs/gpinitsystem_20150625.log
20150625:22:31:03:gpinitsystem:RedHat6:longtop-[INFO]:-To determine level of criticality
20150625:22:31:03:gpinitsystem:RedHat6:longtop-[WARN]:-*******************************************************
20150625:22:31:03:gpinitsystem:RedHat6:longtop-[INFO]:-Greenplum Database instance successfully created
20150625:22:31:03:gpinitsystem:RedHat6:longtop-[INFO]:-------------------------------------------------------
20150625:22:31:03:gpinitsystem:RedHat6:longtop-[INFO]:-To complete the environment configuration, please
20150625:22:31:03:gpinitsystem:RedHat6:longtop-[INFO]:-update longtop .bashrc file with the following
20150625:22:31:03:gpinitsystem:RedHat6:longtop-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced
20150625:22:31:03:gpinitsystem:RedHat6:longtop-[INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/grplum/gpseg-1"
20150625:22:31:04:gpinitsystem:RedHat6:longtop-[INFO]:- to access the Greenplum scripts for this instance:
20150625:22:31:04:gpinitsystem:RedHat6:longtop-[INFO]:- or, use -d /grplum/gpseg-1 option for the Greenplum scripts
20150625:22:31:04:gpinitsystem:RedHat6:longtop-[INFO]:- Example gpstate -d /grplum/gpseg-1
20150625:22:31:04:gpinitsystem:RedHat6:longtop-[INFO]:-Script log file = /home/longtop/gpAdminLogs/gpinitsystem_20150625.log
20150625:22:31:04:gpinitsystem:RedHat6:longtop-[INFO]:-To remove instance, run gpdeletesystem utility
20150625:22:31:04:gpinitsystem:RedHat6:longtop-[INFO]:-To initialize a Standby Master Segment for this Greenplum instance
20150625:22:31:04:gpinitsystem:RedHat6:longtop-[INFO]:-Review options for gpinitstandby
20150625:22:31:04:gpinitsystem:RedHat6:longtop-[INFO]:-------------------------------------------------------
20150625:22:31:04:gpinitsystem:RedHat6:longtop-[INFO]:-The Master /grplum/gpseg-1/pg_hba.conf post gpinitsystem
20150625:22:31:04:gpinitsystem:RedHat6:longtop-[INFO]:-has been configured to allow all hosts within this new
20150625:22:31:04:gpinitsystem:RedHat6:longtop-[INFO]:-array to intercommunicate. Any hosts external to this
20150625:22:31:04:gpinitsystem:RedHat6:longtop-[INFO]:-new array must be explicitly added to this file
20150625:22:31:04:gpinitsystem:RedHat6:longtop-[INFO]:-Refer to the Greenplum Admin support guide which is
20150625:22:31:04:gpinitsystem:RedHat6:longtop-[INFO]:-located in the /usr/local/greenplum-db/./docs directory
20150625:22:31:04:gpinitsystem:RedHat6:longtop-[INFO]:-------------------------------------------------------
[longtop@RedHat6 grplum]$ ls
gp_init_config_example gpseg0 gpseg-1 hostfile soft ---红色是两个生成的目录
[longtop@RedHat6 ~]$ ls
gpAdminLogs
[longtop@RedHat6 ~]$ vi .bashrc
# .bashrc
# Source global definitions
if [ -f /etc/bashrc ]; then
. /etc/bashrc
fi
# User specific aliases and functions
source /usr/local/greenplum-db/greenplum_path.sh
export MASTER_DATA_DIRECTORY=/grplum/gpseg-1
~ 保存退出
[longtop@RedHat6 ~]$ gpstop --停止数据库
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:-Starting gpstop with args:
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:-Gathering information and validating the environment...
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:-Obtaining Greenplum Master catalog information
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:-Obtaining Segment details from master...
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 4.0.4.0 build 3 Single-Node Edition'
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:---------------------------------------------
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:-Master instance parameters
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:---------------------------------------------
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:- Master Greenplum instance process active PID = 12130
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:- Database = template1
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:- Master port = 5432
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:- Master directory = /grplum/gpseg-1
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:- Shutdown mode = smart
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:- Timeout = 60
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:- Shutdown Master standby host = Off
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:---------------------------------------------
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:-Segment instances that will be shutdown:
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:---------------------------------------------
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:- Host Datadir Port Status
20150625:22:34:53:gpstop:RedHat6:longtop-[INFO]:- RedHat6.localdomain /grplum/gpseg0 40000 u
Continue with Greenplum instance shutdown Yy|Nn (default=N):
> y
20150625:22:35:00:gpstop:RedHat6:longtop-[INFO]:-There are 0 connections to the database
20150625:22:35:00:gpstop:RedHat6:longtop-[INFO]:-Commencing Master instance shutdown with mode='smart'
20150625:22:35:00:gpstop:RedHat6:longtop-[INFO]:-Master host=RedHat6.localdomain
20150625:22:35:00:gpstop:RedHat6:longtop-[INFO]:-Commencing Master instance shutdown with mode=smart
20150625:22:35:00:gpstop:RedHat6:longtop-[INFO]:-Master segment instance directory=/grplum/gpseg-1
20150625:22:35:01:gpstop:RedHat6:longtop-[INFO]:-No standby master host configured
20150625:22:35:01:gpstop:RedHat6:longtop-[INFO]:-Commencing parallel segment instance shutdown, please wait...
..
20150625:22:35:03:gpstop:RedHat6:longtop-[INFO]:-----------------------------------------------------
20150625:22:35:03:gpstop:RedHat6:longtop-[INFO]:- Segments stopped successfully = 1
20150625:22:35:03:gpstop:RedHat6:longtop-[INFO]:- Segments with errors during stop = 0
20150625:22:35:03:gpstop:RedHat6:longtop-[INFO]:-----------------------------------------------------
20150625:22:35:03:gpstop:RedHat6:longtop-[INFO]:-Successfully shutdown 1 of 1 segment instances
20150625:22:35:03:gpstop:RedHat6:longtop-[INFO]:-Database successfully shutdown with no errors reported
[longtop@RedHat6 ~]$ gpstart --启动数据库
20150625:22:35:28:gpstart:RedHat6:longtop-[INFO]:-Starting gpstart with args:
20150625:22:35:28:gpstart:RedHat6:longtop-[INFO]:-Gathering information and validating the environment...
20150625:22:35:28:gpstart:RedHat6:longtop-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.0.4.0 build 3 Single-Node Edition'
20150625:22:35:28:gpstart:RedHat6:longtop-[INFO]:-Greenplum Catalog Version: '201005134'
20150625:22:35:28:gpstart:RedHat6:longtop-[INFO]:-Starting Master instance in admin mode
20150625:22:35:29:gpstart:RedHat6:longtop-[INFO]:-Obtaining Greenplum Master catalog information
20150625:22:35:29:gpstart:RedHat6:longtop-[INFO]:-Obtaining Segment details from master...
20150625:22:35:29:gpstart:RedHat6:longtop-[INFO]:-Master Started...
20150625:22:35:29:gpstart:RedHat6:longtop-[INFO]:-Shutting down master
20150625:22:35:30:gpstart:RedHat6:longtop-[INFO]:---------------------------
20150625:22:35:30:gpstart:RedHat6:longtop-[INFO]:-Master instance parameters
20150625:22:35:30:gpstart:RedHat6:longtop-[INFO]:---------------------------
20150625:22:35:30:gpstart:RedHat6:longtop-[INFO]:-Database = template1
20150625:22:35:30:gpstart:RedHat6:longtop-[INFO]:-Master Port = 5432
20150625:22:35:30:gpstart:RedHat6:longtop-[INFO]:-Master directory = /grplum/gpseg-1
20150625:22:35:30:gpstart:RedHat6:longtop-[INFO]:-Timeout = 60 seconds
20150625:22:35:30:gpstart:RedHat6:longtop-[INFO]:-Master standby = Off
20150625:22:35:30:gpstart:RedHat6:longtop-[INFO]:---------------------------------------
20150625:22:35:30:gpstart:RedHat6:longtop-[INFO]:-Segment instances that will be started
20150625:22:35:30:gpstart:RedHat6:longtop-[INFO]:---------------------------------------
20150625:22:35:30:gpstart:RedHat6:longtop-[INFO]:- Host Datadir Port
20150625:22:35:30:gpstart:RedHat6:longtop-[INFO]:- RedHat6.localdomain /grplum/gpseg0 40000
Continue with Greenplum instance startup Yy|Nn (default=N):
> y
20150625:22:35:43:gpstart:RedHat6:longtop-[INFO]:-No standby master configured. skipping...
20150625:22:35:43:gpstart:RedHat6:longtop-[INFO]:-Commencing parallel segment instance startup, please wait...
..
20150625:22:35:45:gpstart:RedHat6:longtop-[INFO]:-Process results...
20150625:22:35:45:gpstart:RedHat6:longtop-[INFO]:-----------------------------------------------------
20150625:22:35:45:gpstart:RedHat6:longtop-[INFO]:- Successful segment starts = 1
20150625:22:35:45:gpstart:RedHat6:longtop-[INFO]:- Failed segment starts = 0
20150625:22:35:45:gpstart:RedHat6:longtop-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20150625:22:35:45:gpstart:RedHat6:longtop-[INFO]:-----------------------------------------------------
20150625:22:35:45:gpstart:RedHat6:longtop-[INFO]:-
20150625:22:35:45:gpstart:RedHat6:longtop-[INFO]:-Successfully started 1 of 1 segment instances
20150625:22:35:45:gpstart:RedHat6:longtop-[INFO]:-----------------------------------------------------
20150625:22:35:45:gpstart:RedHat6:longtop-[INFO]:-Starting Master instance RedHat6.localdomain directory /grplum/gpseg-1
20150625:22:35:46:gpstart:RedHat6:longtop-[INFO]:-Command pg_ctl reports Master RedHat6.localdomain instance active
20150625:22:35:46:gpstart:RedHat6:longtop-[INFO]:-Database successfully started with no errors reported
[longtop@RedHat6 ~]$ gpstate --查看数据库状态
20150625:22:37:20:gpstate:RedHat6:longtop-[INFO]:-Starting gpstate with args:
20150625:22:37:21:gpstate:RedHat6:longtop-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.0.4.0 build 3 Single-Node Edition'
20150625:22:37:21:gpstate:RedHat6:longtop-[INFO]:-Obtaining Segment details from master...
20150625:22:37:21:gpstate:RedHat6:longtop-[INFO]:-Gathering data from segments...
.
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:-Greenplum instance status summary
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:-----------------------------------------------------
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:- Master instance = Active
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:- Master standby = No master standby configured
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:- Total segment instance count from metadata = 1
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:-----------------------------------------------------
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:- Primary Segment Status
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:-----------------------------------------------------
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:- Total primary segments = 1
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:- Total primary segment valid (at master) = 1
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:- Total primary segment failures (at master) = 0
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:- Total number of postmaster.pid files missing = 0
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:- Total number of postmaster.pid files found = 1
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:- Total number of postmaster.pid PIDs missing = 0
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:- Total number of postmaster.pid PIDs found = 1
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:- Total number of /tmp lock files missing = 0
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:- Total number of /tmp lock files found = 1
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:- Total number postmaster processes missing = 0
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:- Total number postmaster processes found = 1
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:-----------------------------------------------------
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:- Mirror Segment Status
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:-----------------------------------------------------
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:- Mirrors not configured on this array
20150625:22:37:22:gpstate:RedHat6:longtop-[INFO]:-----------------------------------------------------
[longtop@RedHat6 ~]$ psql -d chx -- 这个数据库是刚才配置的名称
psql (8.2.14)
Type "help" for help.
chx=# select datname,datdba,encoding,datacl from pg_database;
datname | datdba | encoding | datacl
-----------+--------+----------+----------------------------------
chx | 10 | 6 |
postgres | 10 | 6 |
template1 | 10 | 6 | {=c/longtop,longtop=CTc/longtop}
template0 | 10 | 6 | {=c/longtop,longtop=CTc/longtop}
(4 rows)
chx=# create table tab_test ( id int, name varchar(20), dtime date); --创建一个测试表
NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'id' as the Greenplum Database data distribution key for this table.
HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
CREATE TABLE
chx=# select * from tab_test; ---原来还是空表
id | name | dtime
----+------+-------
(0 rows)
chx=# insert into tab_test values(1, 'zhoulx','2015/06/15'); ---插入一条记录
INSERT 0 1
chx=# select * from tab_test;
id | name | dtime
----+--------+------------
1 | zhoulx | 2015-06-15
(1 row)
----------------------------------------宣布安装greenplum 单机版数据库完成-------------------------------------------
- greenplum单机版
- greenplum 安装与初始化单机版
- greenplum单机安装
- greenplum单机安装方法
- 单机安装greenplum记录
- pgbouncer连接greenplum单机
- greenplum 在单机上安装
- 单机安装Greenplum的小结
- greenplum 在单机上安装
- Greenplum
- greenplum
- greenplum
- GreenPlum
- greenplum
- Greenplum详细安装(可行版)
- greenplum4单机单节点本地安装Installing a Single-Node Greenplum Database Instance
- 单机版泡泡堂
- 甲正进销存 单机版 bt
- 使用Delphi Xe8 开发微信功能 -- （三）微信支付商户平台之查询退款详情
- 基于jQuery的日期控件
- 第一个程序HelloWorld
- 球类
- 《webgl入门指南》学习笔记一three.js与sim.js
- greenplum单机版
- 热门博文推荐
- mybatis3.2.7学习笔记2_一对一、一对多、多对多、延时加载、缓存
- shell中IFS用法
- javaScript语法入门
- Android应用实例之有道辞典
- POJ Frogs' Neighborhood havel-hakimi定理 （简单题）
- SQL的主键和外键约束
- Material设计非得靠Android L吗？看过来，自定View仿elevation效果！
