GreenPlum upgrade to 4.2.5.0

最新推荐文章于 2020-06-23 22:38:54 发布
最新推荐文章于 2020-06-23 22:38:54 发布
阅读量2.3k 收藏
点赞数
分类专栏： ****EMC Pivotal*** GPDB Mangement
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/gtlions/article/details/12883759
版权 
[gpadmin@o564gtser1 ~]$ gpstate
20131020:13:22:59:004254 gpstate:o564gtser1:gpadmin-[INFO]:-Starting gpstate with args:
20131020:13:22:59:004254 gpstate:o564gtser1:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.4.0 build 1'
20131020:13:22:59:004254 gpstate:o564gtser1:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.2.4.0 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Jan 29 2013 14:27:25'
20131020:13:22:59:004254 gpstate:o564gtser1:gpadmin-[INFO]:-Obtaining Segment details from master...
20131020:13:22:59:004254 gpstate:o564gtser1:gpadmin-[INFO]:-Gathering data from segments...
..
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-Greenplum instance status summary
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Master instance                                = Active
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Master standby                                 = No master standby configured
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total segment instance count from metadata     = 2
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Primary Segment Status
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total primary segments                         = 2
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total primary segment valid (at master)        = 2
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total primary segment failures (at master)     = 0
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of postmaster.pid files missing   = 0
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of postmaster.pid files found     = 2
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing    = 0
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found      = 2
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of /tmp lock files missing        = 0
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of /tmp lock files found          = 2
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number postmaster processes missing      = 0
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number postmaster processes found        = 2
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Mirror Segment Status
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Mirrors not configured on this array
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
[gpadmin@o564gtser1 ~]$ psql -l
                  List of databases
   Name    |  Owner  | Encoding |  Access privileges  
-----------+---------+----------+---------------------
 gtlions   | gtlions | UTF8     |
 postgres  | gpadmin | UTF8     |
 template0 | gpadmin | UTF8     | =c/gpadmin          
                                : gpadmin=CTc/gpadmin
 template1 | gpadmin | UTF8     | =c/gpadmin          
                                : gpadmin=CTc/gpadmin
(4 rows)

[gpadmin@o564gtser1 ~]$ psql gtlions -c "select version();"           
                                                                       version                                                                        
------------------------------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 8.2.15 (Greenplum Database 4.2.4.0 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Jan 29 2013 14:27:25
(1 row)

[gpadmin@o564gtser1 ~]$ gpstop -ay
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Starting gpstop with args: -ay
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Gathering information and validating the environment...
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Obtaining Segment details from master...
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 4.2.4.0 build 1'
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-There are 0 connections to the database
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Master host=o564gtser1
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=smart
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Master segment instance directory=/data/master/gtgpseg-1
20131020:13:24:45:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Commencing parallel segment instance shutdown, please wait...
...
20131020:13:24:48:004425 gpstop:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:24:48:004425 gpstop:o564gtser1:gpadmin-[INFO]:-   Segments stopped successfully      = 2
20131020:13:24:48:004425 gpstop:o564gtser1:gpadmin-[INFO]:-   Segments with errors during stop   = 0
20131020:13:24:48:004425 gpstop:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:24:48:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Successfully shutdown 2 of 2 segment instances
20131020:13:24:48:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Database successfully shutdown with no errors reported
[gpadmin@o564gtser1 ~]$ su -
口令：
IP=192.168.56.171
HOSTNAME=o564gtser1
ORACLE_SID=GT10G
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
Greenplum Home=/usr/local/greenplum-db-4.2.4.0
Greenplum Home=/usr/local/greenplum
MASTER_DATA_DIRECTORY=/data/master/gtgpseg-1
[root@o564gtser1 ~]# sh /home/gpadmin/greenplum-db-4.2.5.2-build-1-RHEL5-x86_64.bin

********************************************************************************
You must read and accept the EMC Database license agreement before installing
********************************************************************************

                 SOFTWARE LICENSE AND MAINTENANCE AGREEMENT

           ***  IMPORTANT INFORMATION - PLEASE READ CAREFULLY  ***

This Software contains computer programs and other proprietary material and
information, the use of which is subject to and expressly conditioned upon
acceptance of this Software License and Maintenance Agreement (the "Agreement").

This Agreement is a legally binding document between you (meaning the individual
person or the entity that the individual represents that has obtained the
Software for its internal productive use and not for outright resale) (the
"Customer") and EMC (which means (i) EMC Corporation, if Customer is located in
the United States; (ii) the local EMC sales subsidiary, if Customer is located
in a country in which EMC Corporation has a local sales subsidiary; and (iii)
EMC Information Systems International ("EISI"), if Customer is located outside
the United States and in a country in which EMC Corporation does not have a
local sales subsidiary). Unless EMC agrees otherwise in writing, this Agreement
governs Customer's use of the Software except to the extent all or any portion
of the Software is: (a) the subject of a separate written agreement; or (b)
governed by a third party licensor's terms and conditions. Capitalized terms
have meaning stated in the Agreement.

If Customer does not have a currently enforceable, written and separately signed
software license agreement directly with EMC or the Distributor from whom
Customer obtained this Software, then by clicking on the "Agree" or "Accept" or
similar button at the end of this Agreement, or proceeding with the
installation, downloading, use or reproduction of this Software, or authorizing
any other person to do so, you are representing to EMC that you are (i)
authorized to bind the Customer; and (ii) agreeing on behalf of the Customer

********************************************************************************
Do you accept the EMC Database license agreement? [yes|no]
********************************************************************************

yes

********************************************************************************
Provide the installation path for Greenplum Database or press ENTER to
accept the default installation path: /usr/local/greenplum-db-4.2.5.2
********************************************************************************

    

********************************************************************************
Install Greenplum Database into </usr/local/greenplum-db-4.2.5.2>? [yes|no]
********************************************************************************

yes

********************************************************************************
[Optional] Provide the path to a previous installation of Greenplum Database,
or press ENTER to skip this step. e.g. /usr/local/greenplum-db-4.1.1.3

This installation step will migrate any Greenplum Database extensions from the
provided path to the version currently being installed. This step is optional
and can be run later with:
gppkg --migrate <path_to_old_gphome> /usr/local/greenplum-db-4.2.5.2
********************************************************************************



Extracting product to /usr/local/greenplum-db-4.2.5.2


Skipping migration of Greenplum Database extensions...

********************************************************************************
Installation complete.
Greenplum Database is installed in /usr/local/greenplum-db-4.2.5.2

Greenplum Database documentation is available for download
at http://powerlink.emc.com.
********************************************************************************
[root@o564gtser1 ~]# ll -d /usr/local/greenplum-db*
lrwxrwxrwx  1 gpadmin gpadmin   22 2013-04-09 /usr/local/greenplum-db -> ./greenplum-db-4.2.4.0
drwxr-xr-x 11 gpadmin gpadmin 4096 2013-04-09 /usr/local/greenplum-db-4.2.4.0
drwxr-xr-x 11 root    root    4096 10-20 13:25 /usr/local/greenplum-db-4.2.5.2
[root@o564gtser1 ~]# rm -rf /usr/local/greenplum-db
[root@o564gtser1 ~]# ln -s /usr/local/greenplum-db-4.2.5.2 /usr/local/greenplum-db
[root@o564gtser1 ~]# ll -d /usr/local/greenplum-db*                               
lrwxrwxrwx  1 root    root      31 10-20 13:26 /usr/local/greenplum-db -> /usr/local/greenplum-db-4.2.5.2
drwxr-xr-x 11 gpadmin gpadmin 4096 2013-04-09 /usr/local/greenplum-db-4.2.4.0
drwxr-xr-x 11 root    root    4096 10-20 13:25 /usr/local/greenplum-db-4.2.5.2
[root@o564gtser1 ~]# chown -R gpadmin:gpadmin /usr/local/greenplum-db          
[root@o564gtser1 ~]# source /usr/local/greenplum-db/greenplum_path.sh
[root@o564gtser1 ~]# gpseginstall -f seghost
20131020:13:28:40:004686 gpseginstall:o564gtser1:root-[INFO]:-Installation Info:
link_name greenplum-db
binary_path /usr/local/greenplum-db-4.2.5.2
binary_dir_location /usr/local
binary_dir_name greenplum-db-4.2.5.2
20131020:13:28:40:004686 gpseginstall:o564gtser1:root-[INFO]:-check cluster password access
20131020:13:28:41:004686 gpseginstall:o564gtser1:root-[INFO]:-de-duplicate hostnames
20131020:13:28:41:004686 gpseginstall:o564gtser1:root-[INFO]:-master hostname: o564gtser1
20131020:13:28:41:004686 gpseginstall:o564gtser1:root-[INFO]:-check for user gpadmin on cluster
20131020:13:28:41:004686 gpseginstall:o564gtser1:root-[INFO]:-add user gpadmin on master
20131020:13:28:41:004686 gpseginstall:o564gtser1:root-[INFO]:-add user gpadmin on cluster
20131020:13:28:41:004686 gpseginstall:o564gtser1:root-[INFO]:-chown -R gpadmin:gpadmin /usr/local/greenplum-db
20131020:13:28:42:004686 gpseginstall:o564gtser1:root-[INFO]:-chown -R gpadmin:gpadmin /usr/local/greenplum-db-4.2.5.2
20131020:13:28:42:004686 gpseginstall:o564gtser1:root-[INFO]:-rm -f /usr/local/greenplum-db-4.2.5.2.tar; rm -f /usr/local/greenplum-db-4.2.5.2.tar.gz
20131020:13:28:42:004686 gpseginstall:o564gtser1:root-[INFO]:-cd /usr/local; tar cf greenplum-db-4.2.5.2.tar greenplum-db-4.2.5.2
20131020:13:28:44:004686 gpseginstall:o564gtser1:root-[INFO]:-gzip /usr/local/greenplum-db-4.2.5.2.tar
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-remote command: mkdir -p /usr/local
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-remote command: rm -rf /usr/local/greenplum-db-4.2.5.2
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-scp software to remote location
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-remote command: gzip -f -d /usr/local/greenplum-db-4.2.5.2.tar.gz
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-md5 check on remote location
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-remote command: cd /usr/local; tar xf greenplum-db-4.2.5.2.tar
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-remote command: rm -f /usr/local/greenplum-db-4.2.5.2.tar
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-remote command: cd /usr/local; rm -f greenplum-db; ln -fs greenplum-db-4.2.5.2 greenplum-db
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-remote command: chown -R gpadmin:gpadmin /usr/local/greenplum-db
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-remote command: chown -R gpadmin:gpadmin /usr/local/greenplum-db-4.2.5.2
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-rm -f /usr/local/greenplum-db-4.2.5.2.tar.gz
Please enter a password:
Confirm password:
20131020:13:29:11:004686 gpseginstall:o564gtser1:root-[INFO]:-Changing system passwords ...
20131020:13:29:11:004686 gpseginstall:o564gtser1:root-[INFO]:-exchange ssh keys for user root
20131020:13:29:14:004686 gpseginstall:o564gtser1:root-[INFO]:-exchange ssh keys for user gpadmin
20131020:13:29:14:004686 gpseginstall:o564gtser1:root-[ERROR]:-failed doing a test read of file: su gpadmin -c "cat seghost &> /dev/null"
20131020:13:29:14:004686 gpseginstall:o564gtser1:root-[ERROR]:-seghost is not accessible as user gpadmin
20131020:13:29:14:004686 gpseginstall:o564gtser1:root-[CRITICAL]:-early exit from gpseginstall
[root@o564gtser1 ~]# exit
[gpadmin@o564gtser1 ~]$ gpstart -ay
20131020:13:30:30:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Starting gpstart with args: -ay
20131020:13:30:30:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Gathering information and validating the environment...
20131020:13:30:30:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.2.5.2 build 1'
20131020:13:30:30:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Greenplum Catalog Version: '201109210'
20131020:13:30:30:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Starting Master instance in admin mode
20131020:13:30:31:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20131020:13:30:31:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Obtaining Segment details from master...
20131020:13:30:31:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Setting new master era
20131020:13:30:31:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Master Started...
20131020:13:30:31:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Checking for filespace consistency
20131020:13:30:31:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Obtaining current filespace entries used by TRANSACTION_FILES
20131020:13:30:32:005040 gpstart:o564gtser1:gpadmin-[INFO]:-TRANSACTION_FILES OIDs are consistent for gtlionsfilespace filespace
20131020:13:30:33:005040 gpstart:o564gtser1:gpadmin-[INFO]:-TRANSACTION_FILES entries are consistent for gtlionsfilespace filespace
20131020:13:30:33:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Checking for filespace consistency
20131020:13:30:33:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Obtaining current filespace entries used by TEMPORARY_FILES
20131020:13:30:34:005040 gpstart:o564gtser1:gpadmin-[INFO]:-TEMPORARY_FILES OIDs are consistent for gtlionsfilespace filespace
20131020:13:30:35:005040 gpstart:o564gtser1:gpadmin-[INFO]:-TEMPORARY_FILES entries are consistent for gtlionsfilespace filespace
20131020:13:30:35:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Shutting down master
20131020:13:30:36:005040 gpstart:o564gtser1:gpadmin-[INFO]:-No standby master configured.  skipping...
20131020:13:30:36:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
..
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Process results...
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-   Successful segment starts                                            = 2
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-   Failed segment starts                                                = 0
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Starting Master instance o564gtser1 directory /data/master/gtgpseg-1
20131020:13:30:39:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Command pg_ctl reports Master o564gtser1 instance active
20131020:13:30:39:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Database successfully started
[gpadmin@o564gtser1 ~]$ gpstate
20131020:13:30:45:005663 gpstate:o564gtser1:gpadmin-[INFO]:-Starting gpstate with args:
20131020:13:30:45:005663 gpstate:o564gtser1:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.5.2 build 1'
20131020:13:30:45:005663 gpstate:o564gtser1:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.2.5.2 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on May 16 2013 23:35:01'
20131020:13:30:45:005663 gpstate:o564gtser1:gpadmin-[INFO]:-Obtaining Segment details from master...
20131020:13:30:45:005663 gpstate:o564gtser1:gpadmin-[INFO]:-Gathering data from segments...
...
20131020:13:30:48:005663 gpstate:o564gtser1:gpadmin-[INFO]:-Greenplum instance status summary
20131020:13:30:48:005663 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:30:48:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Master instance                                = Active
20131020:13:30:48:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Master standby                                 = No master standby configured
20131020:13:30:48:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total segment instance count from metadata     = 2
20131020:13:30:48:005663 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Primary Segment Status
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total primary segments                         = 2
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total primary segment valid (at master)        = 2
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total primary segment failures (at master)     = 0
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of postmaster.pid files missing   = 0
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of postmaster.pid files found     = 2
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing    = 0
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found      = 2
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of /tmp lock files missing        = 0
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of /tmp lock files found          = 2
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number postmaster processes missing      = 0
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number postmaster processes found        = 2
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Mirror Segment Status
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Mirrors not configured on this array
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
[gpadmin@o564gtser1 ~]$ psql gtlions -c "select version();"
                                                                       version                                                                        
------------------------------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 8.2.15 (Greenplum Database 4.2.5.2 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on May 16 2013 23:35:01
(1 row)
-EOF-


gtlions
关注
专栏目录
Greenplum5.4.0分布式集群（4节点）安装与配置
sfrem的专栏
12-26 1361
Greenplum5.4.0分布式集群（4节点）安装与配置 1、环境介绍 Vmware虚拟机,4台 操作系统：Centos 7.4 硬件资源配置： CPU：1 内存：1Gb 磁盘空间：20Gb 操作系统：centos 7.4(64) Greenpoum5.4.0分布式集群,4节点 集群规划，详细如下： 192.168.2.10 gpdb01 主节点 192.168.2.11 gpdb02 主节点切换备份节点 ...
Greenplum开源升级工具gpupgrade beta版，欢迎试用！
Greenplum中文社区
11-02 517
了解更多Greenplum技术干货，欢迎访问Greenplum中文社区网站 自2019年起，Greenplum数据库团队就开始致力于构建Greenplum原地升级工具gpupgrade。gpupgrade致力于提供一个简便的升级途径帮助用户在升级的过程中减少时间和空间的消耗。该工具将使客户能够方便放心的快速升级到Greenplum数据库的最新版本，让Greenplum在快速迭代的同时更快的获得客户反馈。 Greenplum研发团队从用户那收集了升级需求，并将收集来的需求进行了综合和分级。在充分了解用户对.
Greenplum upgrade from 4.3.4.1 to 4.3.30.0 准备工作
魂醉的一亩二分地
11-06 365
2015年升级后，最近几年没有进行升级，最近查看官网看到已经升级到了4.3.30.0版本，对一些工具都打了补丁，具体可见链接https://gpdb.docs.pivotal.io/43300/relnotes/GPDB_43300_README.html 升级前的准备工作 1.保证升级可以回滚 2.按官方文档提示的升级相关视图，修改相关参数 第一步首先保证greenplum 4.3.4....
Centos7下安装Greenplum 6.8-安装
肥叔菌的博客
06-23 8155
介绍如何在所有主机上安装Greenplum Database软件二进制文件，为gpadmin启用无密码SSH，以及如何验证安装。 安装Greenplum数据库 您必须在Greenplum数据库系统的每台主机上安装Greenplum数据库。Pivotal将Greenplum数据库软件作为可下载的软件包分发，您可以使用操作系统的软件包管理系统将其安装在每个主机系统上。您可以从Pivotal Network下载该软件包。在开始安装Greenplum Database之前，请确保已完成“ 配置系统”中的步骤， 以配
greenplum安装方法详解
热门推荐
蝈蝈的博客
07-18 1万+
greenplum-db-4.2.2.4-build-1-CE-RHEL5-i386安装方法详解
Greenplum upgrade from 4.3.4.1 to 4.3.30.0
魂醉的一亩二分地
11-06 476
这一篇主要介绍升级，升级步骤 1.切换至gpadmin用户，关闭仓库 2.在主节点运行4.3.30.0的bin文件 3.升级使用的是软连接，所以只要建立相关目录的软连接即可 4.在所有segment节点安装软件 5.检查C语言库文件 6.启动仓库 1.关闭仓库 su - gpadmin gpstop -M fast 2.解压并在master节点安装新版本的greenplum unz...
GREENPLUM4.2.2.4版本数据库下载
conglei2565的博客
10-30 369
4.2.2的最新补丁版本，仅供研究学习使用 SUSE X64 http://www.kuaipan.cn/file/id_28721511460241593.htm REHL X64 http://ww...
Greenplum-db-4.2.2.4-build-1-CE-RHEL5-i386安装文件(验证绝对可用)
02-26
《Greenplum数据库4.2.2.4在RHEL5-i386系统上的安装指南》 Greenplum数据库，作为一个高度可扩展并行数据库系统，被广泛应用于大数据处理和分析领域。版本4.2.2.4是其发展过程中的一个重要里程碑，提供了高效的查询...
greenplum-db-4.2.2.4-build-1-CE-RHEL5-i386
07-15
**绿松石数据库（Greenplum）4.2.2.4详解** 绿松石数据库（Greenplum）是一款高效的企业级数据仓库解决方案，由Pivotal公司开发，以其并行处理能力和大数据处理能力而闻名。这个特定的版本——4.2.2.4，是针对Red ...
greenplum-db-4.2.8.0-build-1-RHEL5-x86_64
07-10
《Greenplum数据库4.2.8.0在Red Hat 5上的安装指南》 Greenplum数据库系统是一款高效的企业级并行数据仓库解决方案，它基于PostgreSQL，并扩展了其性能和可扩展性，适用于大数据分析和处理。本文将详细阐述如何在...
GreenPlum的JDBC连接.zip
01-07
`GreenplumDriver.jar` 文件是GreenPlum JDBC驱动程序的实现，它允许Java程序员连接到GreenPlum数据库并执行SQL查询和其他数据库操作。 JDBC是Java中用于与各种类型的关系型数据库进行通信的标准化API。它提供了一...
Greenplum日常维护手册.pdf
09-29
根据提供的信息，我们可以总结出以下有关Greenplum日常维护的关键知识点： ### Greenplum数据库启动与停止 #### 数据库启动 `gpstart` - **基本用法**：`gpstart` 命令用于启动Greenplum数据库集群。 - **常用参数...
Greenplum管理索引
Gtlions Tracker
04-24 6294
鉴于OLAP系统的特性，应该谨慎并保守地使用索引。避免在频繁更新的列上使用索引；在高选择性的列上使用B-tree索引；在低选择性的列上使用Bitmap索引。 通常来说在传统数据库中使用索引可以有效的提高数据访问效率，特别是在OLTP系统中，往往只是需要从大表中获取几行或者部分的数据记录，这个情况下索引确实是特别有效的提高数据获取速度的方法。但是在gp中未必如此，因为首先数据都是均匀最大可能的均匀
idle in transaction
Gtlions Tracker
11-25 4338
检查库的时候发现有8个超过17个小时的会话，执行状态为 idle in transaction。 从文档上可以看到解释： idle in transaction (waiting for client inside a BEGIN block) 通知开发提交或者回滚，抑或杀之。 -EOF-
Greenplum管理表空间Tablespace
Gtlions Tracker
04-19 3561
create tablespace gtlions_ts1 [owner gtlions] filespace gtlionsfilespace; alter tablespace gtlions_ts1 rename to gtlions_ts2; alter tablespace gtlions_ts1 owner to gtlions; 表空间是基于文件空间filespace的，实
GP加载和卸载数据之一外部表--有更新版本！
Gtlions Tracker
04-30 3479
7.0. 方式 在gp中提供了几种方式用于加载和卸载数据：external tables、gpload、copy等等，这几种方式没有优劣之分，只是在不同场景下使用不同的技术而已。 7.1. 外部表 本文将首先测试使用外部表的方式进行加载和卸载数据。 外部表-external tables，分为只读readable和只写writable两种类别，而每种又可以分为常规regular和web两种
修改gp集群主机名称
Gtlions Tracker
12-29 3473
在某些情况下，特别是在前期没规划好的情况下，后期运行过程中会遇到需要修改hostname&ip的情况，现状遇到的情况是需要调整hostname，对于某些已经投产或者的集群类的环境，修改这些信息尤为麻烦。 大体步骤： 0. 维护模式打开数据库，修改配置表 gp_segment_configuration 的hostname和address字段为新主机名称； 1、停库，关闭维护模式； 2、修改
SQLSTATE58030
Gtlions Tracker
12-02 3354
在优化一条SQL的时候遇到了执行错误 gtlions =# select t1.telnumber,t2.ua,t2.url,t1.apply_name,t2.apply_name from tb1 t1 gtlions -# left outer join tb2 t2 on t1.sid = t2.ipsid gtlions-# where t1.sum_date=20141128 a
Mac OSX下编译安装PostgreSQL
Gtlions Tracker
11-03 3168
原先使用的是官方提供的安装包，但是安装包会创建postgre这个用户，在登陆界面看的有点不爽，搜索了半天竟然没有找到如何在osx下编译安装的教程，而且如果是按照官方文档的编译安装办法一定会让你崩溃，本着源码安装都类似的想法，根据以往在Linux下的经验竟然一把通过了，注意要安装COMMANDER LINE DEVELOPERS就是了。 ./configure make sudo mk
Greenplum 4.2数据库管理员指南
本资源是一份名为《Greenplum®Database 4.2数据库管理员指南》的文档，由EMC Corporation发布并保留版权。该文档更新日期为2013年9月，适用于Greenplum Database 4.2版本，版本号为6.3。Greenplum Database是一款...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值