大版本升级额外步骤,版本升级步骤
这里的大版本是指版本号的第2位数字,比如4.2.7.3升级到4.3.3.1,从4.2升级到4.3,会出现无法启动问题,提示catalog版本不兼容。而如果只是在第2位数字之内的相同版本的升级没有此类问题;最前面的那个版本数字号由于目前还没有出现对应版本,所以没有相关问题。
[gpadmin@gtlions60 ~]$ gpstart -a 20141019:12:40:51:004622 gpstart:gtlions60:gpadmin-[INFO]:-Starting gpstart with args: -a 20141019:12:40:51:004622 gpstart:gtlions60:gpadmin-[INFO]:-Gathering information and validating the environment... 20141019:12:40:52:004622 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1' 20141019:12:40:52:004622 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150' 20141019:12:40:52:004622 gpstart:gtlions60:gpadmin-[INFO]:-MASTER_DIRECTORY Catalog Version: '201109210' 20141019:12:40:52:004622 gpstart:gtlions60:gpadmin-[INFO]:-Catalog Version of master directory incompatible with binaries 20141019:12:40:52:004622 gpstart:gtlions60:gpadmin-[ERROR]:-gpstart error: Catalog Versions are incompatible
解决版本是使用gpmigrator对数据库做个迁移升级操作(catalog):
[gpadmin@gtlions60 ~]$ gpmigrator /usr/local/greenplum-db-4.2.7.3 /usr/local/greenplum-db-4.3.3.1 20141019:12:44:13:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Beginning upgrade 20141019:12:44:13:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Checking configuration 20141019:12:44:14:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-gpmigrator version 4.3.3.1 build 1 20141019:12:44:14:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Python version 2.6.2 final 0 20141019:12:44:14:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Operating System: Linux 2.6.32-220.el6.x86_64 20141019:12:44:14:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Checking version compatibility 20141019:12:44:14:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Source Version: (Greenplum Database) 4.2.7.3 build 1 20141019:12:44:14:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Target Version: (Greenplum Database) 4.3.3.1 build 1 20141019:12:44:14:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Source Catalog version number: 201109210 20141019:12:44:14:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Target Catalog version number: 201310150 20141019:12:44:14:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Data Catalog version number: 201109210 20141019:12:44:14:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Versions are compatible 20141019:12:44:14:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Postmaster not running 20141019:12:44:14:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Starting old Greenplum postmaster 20141019:12:44:21:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Extracting configuration information 20141019:12:44:22:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Checking that all segments are valid 20141019:12:44:22:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Creating list of databases 20141019:12:44:22:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Checking gpmigrator user 20141019:12:44:22:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Validating hosts 20141019:12:44:22:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Validating indexes 20141019:12:44:22:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Validating database encoding 20141019:12:44:22:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Configuration acquired 20141019:12:44:22:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Creating temporary directories 20141019:12:44:24:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Checking Segment binary version 20141019:12:44:24:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Checking GUCs 20141019:12:44:24:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Checking Free Space 20141019:12:44:24:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Checking Catalog 20141019:12:44:24:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-... Checking template1 20141019:12:45:07:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-... Checking postgres 20141019:12:45:50:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-... Checking gtlions 20141019:12:46:34:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Locking database 20141019:12:46:34:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-... Creating upgrade user 20141019:12:46:34:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-... Creating pg_hba.conf 20141019:12:46:34:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-... Syncing 20141019:12:46:35:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Database Locked 20141019:12:46:35:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Generating config files 20141019:12:46:35:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Configuration files generated 20141019:12:46:36:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Extracting list of catalog files 20141019:12:46:37:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Shutting down old Greenplum postmaster 20141019:12:46:42:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Looking for highest OID 20141019:12:46:43:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Building skeleton cluster 20141019:12:46:53:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Modifying catalog version of skeleton cluster 20141019:12:46:55:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Adjusting configuration 20141019:12:46:55:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Starting new Greenplum postmaster in utility mode 20141019:12:46:57:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Shutting down new Greenplum postmaster 20141019:12:46:59:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Starting new Greenplum postmaster in upgrade mode 20141019:12:47:08:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Shutting down new Greenplum postmaster 20141019:12:47:13:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Starting new Greenplum postmaster in upgrade mode 20141019:12:47:20:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Performing catalog transformation 20141019:12:47:20:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-... template1 20141019:12:47:22:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-... template0 20141019:12:47:24:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-... postgres 20141019:12:47:26:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-... gtlions 20141019:12:47:29:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Shutting down new Greenplum postmaster 20141019:12:47:33:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Unlocking database 20141019:12:47:34:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Postmaster not running 20141019:12:47:34:004635 gpmigrator:gtlions60:gpadmin-[INFO]:--------------------------------------------------- 20141019:12:47:34:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Stage 1 complete 20141019:12:47:34:004635 gpmigrator:gtlions60:gpadmin-[INFO]:--------------------------------------------------- 20141019:12:47:34:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Adding gp_dbid file 20141019:12:47:35:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Linking backup 20141019:12:47:35:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-... This may take a while 20141019:12:47:39:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Linking upgrade 20141019:12:47:39:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-... This may take a while 20141019:12:47:40:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Adjusting configuration 20141019:12:47:40:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Starting new Greenplum postmaster in utility mode 20141019:12:47:42:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Shutting down new Greenplum postmaster 20141019:12:47:43:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Starting new Greenplum postmaster in upgrade mode 20141019:12:47:50:004635 gpmigrator:gtlions60:gpadmin-[WARNING]:-*************************************** 20141019:12:47:50:004635 gpmigrator:gtlions60:gpadmin-[WARNING]:-Warnings generated starting cluster 20141019:12:47:50:004635 gpmigrator:gtlions60:gpadmin-[WARNING]:-Check /home/gpadmin/gpAdminLogs/gpstart_20141019.log for detailed warnings 20141019:12:47:50:004635 gpmigrator:gtlions60:gpadmin-[WARNING]:-*************************************** 20141019:12:47:50:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Shutting down new Greenplum postmaster 20141019:12:47:55:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Starting new Greenplum postmaster 20141019:12:48:02:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Installing gp_toolkit 20141019:12:48:05:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Removing upgrade user 20141019:12:48:05:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Unlocking database 20141019:12:48:18:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Removing temporary directories 20141019:12:48:18:004635 gpmigrator:gtlions60:gpadmin-[INFO]:---------------------------------------------------- 20141019:12:48:18:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Upgrade Successful 20141019:12:48:18:004635 gpmigrator:gtlions60:gpadmin-[INFO]:---------------------------------------------------- 20141019:12:48:18:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-Please consult release notes for post-upgrade 20141019:12:48:18:004635 gpmigrator:gtlions60:gpadmin-[INFO]:-instructions to complete environment configuration 20141019:12:48:18:004635 gpmigrator:gtlions60:gpadmin-[INFO]:---------------------------------------------------- [gpadmin@gtlions60 ~]$ cat /home/gpadmin/gpAdminLogs/gpstart_20141019.log 20141019:11:51:17:002597 gpstart:gtlions60:gpadmin-[INFO]:-Starting gpstart with args: -a 20141019:11:51:17:002597 gpstart:gtlions60:gpadmin-[INFO]:-Gathering information and validating the environment... 20141019:11:51:17:002597 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.2.7.3 build 1' 20141019:11:51:17:002597 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Catalog Version: '201109210' 20141019:11:51:18:002597 gpstart:gtlions60:gpadmin-[INFO]:-Starting Master instance in admin mode 20141019:11:51:21:002597 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20141019:11:51:21:002597 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Segment details from master... 20141019:11:51:21:002597 gpstart:gtlions60:gpadmin-[INFO]:-Setting new master era 20141019:11:51:21:002597 gpstart:gtlions60:gpadmin-[INFO]:-Master Started... 20141019:11:51:21:002597 gpstart:gtlions60:gpadmin-[INFO]:-Shutting down master 20141019:11:51:23:002597 gpstart:gtlions60:gpadmin-[INFO]:-No standby master configured. skipping... 20141019:11:51:23:002597 gpstart:gtlions60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait... 20141019:11:51:29:002597 gpstart:gtlions60:gpadmin-[INFO]:-Process results... 20141019:11:51:29:002597 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:11:51:29:002597 gpstart:gtlions60:gpadmin-[INFO]:- Successful segment starts = 2 20141019:11:51:29:002597 gpstart:gtlions60:gpadmin-[INFO]:- Failed segment starts = 0 20141019:11:51:29:002597 gpstart:gtlions60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0 20141019:11:51:29:002597 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:11:51:29:002597 gpstart:gtlions60:gpadmin-[INFO]:- 20141019:11:51:29:002597 gpstart:gtlions60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances 20141019:11:51:29:002597 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:11:51:29:002597 gpstart:gtlions60:gpadmin-[INFO]:-Starting Master instance gtlions60 directory /data/master/gpseg-1 20141019:11:51:32:002597 gpstart:gtlions60:gpadmin-[INFO]:-Command pg_ctl reports Master gtlions60 instance active 20141019:11:51:32:002597 gpstart:gtlions60:gpadmin-[INFO]:-Database successfully started 20141019:12:35:54:003894 gpstart:gtlions60:gpadmin-[INFO]:-Starting gpstart with args: -a 20141019:12:35:54:003894 gpstart:gtlions60:gpadmin-[INFO]:-Gathering information and validating the environment... 20141019:12:35:54:003894 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1' 20141019:12:35:54:003894 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150' 20141019:12:35:54:003894 gpstart:gtlions60:gpadmin-[INFO]:-MASTER_DIRECTORY Catalog Version: '201109210' 20141019:12:35:54:003894 gpstart:gtlions60:gpadmin-[INFO]:-Catalog Version of master directory incompatible with binaries 20141019:12:35:54:003894 gpstart:gtlions60:gpadmin-[ERROR]:-gpstart error: Catalog Versions are incompatible 20141019:12:38:18:004191 gpstart:gtlions60:gpadmin-[INFO]:-Starting gpstart with args: -a 20141019:12:38:18:004191 gpstart:gtlions60:gpadmin-[INFO]:-Gathering information and validating the environment... 20141019:12:38:18:004191 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1' 20141019:12:38:18:004191 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150' 20141019:12:38:18:004191 gpstart:gtlions60:gpadmin-[INFO]:-MASTER_DIRECTORY Catalog Version: '201109210' 20141019:12:38:18:004191 gpstart:gtlions60:gpadmin-[INFO]:-Catalog Version of master directory incompatible with binaries 20141019:12:38:18:004191 gpstart:gtlions60:gpadmin-[ERROR]:-gpstart error: Catalog Versions are incompatible 20141019:12:40:51:004622 gpstart:gtlions60:gpadmin-[INFO]:-Starting gpstart with args: -a 20141019:12:40:51:004622 gpstart:gtlions60:gpadmin-[INFO]:-Gathering information and validating the environment... 20141019:12:40:52:004622 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1' 20141019:12:40:52:004622 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150' 20141019:12:40:52:004622 gpstart:gtlions60:gpadmin-[INFO]:-MASTER_DIRECTORY Catalog Version: '201109210' 20141019:12:40:52:004622 gpstart:gtlions60:gpadmin-[INFO]:-Catalog Version of master directory incompatible with binaries 20141019:12:40:52:004622 gpstart:gtlions60:gpadmin-[ERROR]:-gpstart error: Catalog Versions are incompatible 20141019:12:44:14:004663 gpstart:gtlions60:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs 20141019:12:44:14:004663 gpstart:gtlions60:gpadmin-[INFO]:-Gathering information and validating the environment... 20141019:12:44:14:004663 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.2.7.3 build 1' 20141019:12:44:14:004663 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Catalog Version: '201109210' 20141019:12:44:14:004663 gpstart:gtlions60:gpadmin-[INFO]:-Starting Master instance in admin mode 20141019:12:44:15:004663 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20141019:12:44:15:004663 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Segment details from master... 20141019:12:44:15:004663 gpstart:gtlions60:gpadmin-[INFO]:-Setting new master era 20141019:12:44:15:004663 gpstart:gtlions60:gpadmin-[INFO]:-Master Started... 20141019:12:44:15:004663 gpstart:gtlions60:gpadmin-[INFO]:-Shutting down master 20141019:12:44:17:004663 gpstart:gtlions60:gpadmin-[INFO]:-No standby master configured. skipping... 20141019:12:44:17:004663 gpstart:gtlions60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait... 20141019:12:44:19:004663 gpstart:gtlions60:gpadmin-[INFO]:-Process results... 20141019:12:44:19:004663 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:44:19:004663 gpstart:gtlions60:gpadmin-[INFO]:- Successful segment starts = 2 20141019:12:44:19:004663 gpstart:gtlions60:gpadmin-[INFO]:- Failed segment starts = 0 20141019:12:44:19:004663 gpstart:gtlions60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0 20141019:12:44:19:004663 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:44:19:004663 gpstart:gtlions60:gpadmin-[INFO]:- 20141019:12:44:19:004663 gpstart:gtlions60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances 20141019:12:44:19:004663 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:44:19:004663 gpstart:gtlions60:gpadmin-[INFO]:-Starting Master instance gtlions60 directory /data/master/gpseg-1 20141019:12:44:21:004663 gpstart:gtlions60:gpadmin-[INFO]:-Command pg_ctl reports Master gtlions60 instance active 20141019:12:44:21:004663 gpstart:gtlions60:gpadmin-[INFO]:-Database successfully started 20141019:12:46:55:025211 gpstart:gtlions60:gpadmin-[INFO]:-Starting gpstart with args: -a -m -U upgrade -l /home/gpadmin/gpAdminLogs 20141019:12:46:55:025211 gpstart:gtlions60:gpadmin-[INFO]:-Gathering information and validating the environment... 20141019:12:46:55:025211 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1' 20141019:12:46:55:025211 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150' 20141019:12:46:56:025211 gpstart:gtlions60:gpadmin-[INFO]:-Master-only start requested for management utilities. 20141019:12:46:56:025211 gpstart:gtlions60:gpadmin-[INFO]:-Starting Master instance in admin mode 20141019:12:46:57:025211 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20141019:12:46:57:025211 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Segment details from master... 20141019:12:46:57:025211 gpstart:gtlions60:gpadmin-[INFO]:-Setting new master era 20141019:12:46:57:025211 gpstart:gtlions60:gpadmin-[INFO]:-Master Started... 20141019:12:46:59:025260 gpstart:gtlions60:gpadmin-[INFO]:-Starting gpstart with args: -a -U upgrade -l /home/gpadmin/gpAdminLogs 20141019:12:46:59:025260 gpstart:gtlions60:gpadmin-[INFO]:-Gathering information and validating the environment... 20141019:12:46:59:025260 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1' 20141019:12:46:59:025260 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150' 20141019:12:46:59:025260 gpstart:gtlions60:gpadmin-[INFO]:-Starting Master instance in admin mode 20141019:12:47:00:025260 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20141019:12:47:00:025260 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Segment details from master... 20141019:12:47:00:025260 gpstart:gtlions60:gpadmin-[INFO]:-Setting new master era 20141019:12:47:00:025260 gpstart:gtlions60:gpadmin-[INFO]:-Master Started... 20141019:12:47:00:025260 gpstart:gtlions60:gpadmin-[INFO]:-Shutting down master 20141019:12:47:02:025260 gpstart:gtlions60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait... 20141019:12:47:06:025260 gpstart:gtlions60:gpadmin-[INFO]:-Process results... 20141019:12:47:06:025260 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:47:06:025260 gpstart:gtlions60:gpadmin-[INFO]:- Successful segment starts = 2 20141019:12:47:06:025260 gpstart:gtlions60:gpadmin-[INFO]:- Failed segment starts = 0 20141019:12:47:06:025260 gpstart:gtlions60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0 20141019:12:47:06:025260 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:47:06:025260 gpstart:gtlions60:gpadmin-[INFO]:- 20141019:12:47:06:025260 gpstart:gtlions60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances 20141019:12:47:06:025260 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:47:06:025260 gpstart:gtlions60:gpadmin-[INFO]:-Starting Master instance gtlions60 directory /data/master/gpmigrator/upgrade/gpseg-1 20141019:12:47:07:025260 gpstart:gtlions60:gpadmin-[INFO]:-Command pg_ctl reports Master gtlions60 instance active 20141019:12:47:07:025260 gpstart:gtlions60:gpadmin-[INFO]:-Testing connection as user gpadmin 20141019:12:47:07:025260 gpstart:gtlions60:gpadmin-[INFO]:-No standby master configured. skipping... 20141019:12:47:07:025260 gpstart:gtlions60:gpadmin-[INFO]:-Database successfully started 20141019:12:47:13:025573 gpstart:gtlions60:gpadmin-[INFO]:-Starting gpstart with args: -a -U upgrade -l /home/gpadmin/gpAdminLogs 20141019:12:47:13:025573 gpstart:gtlions60:gpadmin-[INFO]:-Gathering information and validating the environment... 20141019:12:47:13:025573 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1' 20141019:12:47:13:025573 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150' 20141019:12:47:14:025573 gpstart:gtlions60:gpadmin-[INFO]:-Starting Master instance in admin mode 20141019:12:47:15:025573 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20141019:12:47:15:025573 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Segment details from master... 20141019:12:47:15:025573 gpstart:gtlions60:gpadmin-[INFO]:-Setting new master era 20141019:12:47:15:025573 gpstart:gtlions60:gpadmin-[INFO]:-Master Started... 20141019:12:47:15:025573 gpstart:gtlions60:gpadmin-[INFO]:-Shutting down master 20141019:12:47:16:025573 gpstart:gtlions60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait... 20141019:12:47:18:025573 gpstart:gtlions60:gpadmin-[INFO]:-Process results... 20141019:12:47:18:025573 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:47:18:025573 gpstart:gtlions60:gpadmin-[INFO]:- Successful segment starts = 2 20141019:12:47:18:025573 gpstart:gtlions60:gpadmin-[INFO]:- Failed segment starts = 0 20141019:12:47:18:025573 gpstart:gtlions60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0 20141019:12:47:18:025573 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:47:18:025573 gpstart:gtlions60:gpadmin-[INFO]:- 20141019:12:47:18:025573 gpstart:gtlions60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances 20141019:12:47:18:025573 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:47:18:025573 gpstart:gtlions60:gpadmin-[INFO]:-Starting Master instance gtlions60 directory /data/master/gpmigrator/upgrade/gpseg-1 20141019:12:47:20:025573 gpstart:gtlions60:gpadmin-[INFO]:-Command pg_ctl reports Master gtlions60 instance active 20141019:12:47:20:025573 gpstart:gtlions60:gpadmin-[INFO]:-Testing connection as user gpadmin 20141019:12:47:20:025573 gpstart:gtlions60:gpadmin-[INFO]:-No standby master configured. skipping... 20141019:12:47:20:025573 gpstart:gtlions60:gpadmin-[INFO]:-Database successfully started 20141019:12:47:40:027611 gpstart:gtlions60:gpadmin-[INFO]:-Starting gpstart with args: -a -m -l /home/gpadmin/gpAdminLogs 20141019:12:47:40:027611 gpstart:gtlions60:gpadmin-[INFO]:-Gathering information and validating the environment... 20141019:12:47:40:027611 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1' 20141019:12:47:40:027611 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150' 20141019:12:47:40:027611 gpstart:gtlions60:gpadmin-[INFO]:-Master-only start requested for management utilities. 20141019:12:47:40:027611 gpstart:gtlions60:gpadmin-[INFO]:-Starting Master instance in admin mode 20141019:12:47:42:027611 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20141019:12:47:42:027611 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Segment details from master... 20141019:12:47:42:027611 gpstart:gtlions60:gpadmin-[INFO]:-Setting new master era 20141019:12:47:42:027611 gpstart:gtlions60:gpadmin-[INFO]:-Master Started... 20141019:12:47:44:027653 gpstart:gtlions60:gpadmin-[INFO]:-Starting gpstart with args: -a -U upgrade -l /home/gpadmin/gpAdminLogs 20141019:12:47:44:027653 gpstart:gtlions60:gpadmin-[INFO]:-Gathering information and validating the environment... 20141019:12:47:44:027653 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1' 20141019:12:47:44:027653 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150' 20141019:12:47:44:027653 gpstart:gtlions60:gpadmin-[INFO]:-Starting Master instance in admin mode 20141019:12:47:45:027653 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20141019:12:47:45:027653 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Segment details from master... 20141019:12:47:45:027653 gpstart:gtlions60:gpadmin-[INFO]:-Setting new master era 20141019:12:47:45:027653 gpstart:gtlions60:gpadmin-[INFO]:-Master Started... 20141019:12:47:45:027653 gpstart:gtlions60:gpadmin-[INFO]:-Shutting down master 20141019:12:47:47:027653 gpstart:gtlions60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait... 20141019:12:47:49:027653 gpstart:gtlions60:gpadmin-[INFO]:-Process results... 20141019:12:47:49:027653 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:47:49:027653 gpstart:gtlions60:gpadmin-[INFO]:- Successful segment starts = 2 20141019:12:47:49:027653 gpstart:gtlions60:gpadmin-[INFO]:- Failed segment starts = 0 20141019:12:47:49:027653 gpstart:gtlions60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0 20141019:12:47:49:027653 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:47:49:027653 gpstart:gtlions60:gpadmin-[INFO]:- 20141019:12:47:49:027653 gpstart:gtlions60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances 20141019:12:47:49:027653 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:47:49:027653 gpstart:gtlions60:gpadmin-[INFO]:-Starting Master instance gtlions60 directory /data/master/gpmigrator/upgrade/gpseg-1 20141019:12:47:50:027653 gpstart:gtlions60:gpadmin-[WARNING]:-Command pg_ctl reports Master /data/master/gpseg-1 on port 5432 not running 20141019:12:47:50:027653 gpstart:gtlions60:gpadmin-[WARNING]:-Master could not be started 20141019:12:47:55:027904 gpstart:gtlions60:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs 20141019:12:47:55:027904 gpstart:gtlions60:gpadmin-[INFO]:-Gathering information and validating the environment... 20141019:12:47:55:027904 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1' 20141019:12:47:56:027904 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150' 20141019:12:47:56:027904 gpstart:gtlions60:gpadmin-[INFO]:-Starting Master instance in admin mode 20141019:12:47:57:027904 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20141019:12:47:57:027904 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Segment details from master... 20141019:12:47:57:027904 gpstart:gtlions60:gpadmin-[INFO]:-Setting new master era 20141019:12:47:57:027904 gpstart:gtlions60:gpadmin-[INFO]:-Master Started... 20141019:12:47:57:027904 gpstart:gtlions60:gpadmin-[INFO]:-Shutting down master 20141019:12:47:58:027904 gpstart:gtlions60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait... 20141019:12:48:00:027904 gpstart:gtlions60:gpadmin-[INFO]:-Process results... 20141019:12:48:00:027904 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:48:00:027904 gpstart:gtlions60:gpadmin-[INFO]:- Successful segment starts = 2 20141019:12:48:00:027904 gpstart:gtlions60:gpadmin-[INFO]:- Failed segment starts = 0 20141019:12:48:00:027904 gpstart:gtlions60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0 20141019:12:48:00:027904 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:48:00:027904 gpstart:gtlions60:gpadmin-[INFO]:- 20141019:12:48:00:027904 gpstart:gtlions60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances 20141019:12:48:00:027904 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:48:00:027904 gpstart:gtlions60:gpadmin-[INFO]:-Starting Master instance gtlions60 directory /data/master/gpseg-1 20141019:12:48:02:027904 gpstart:gtlions60:gpadmin-[INFO]:-Command pg_ctl reports Master gtlions60 instance active 20141019:12:48:02:027904 gpstart:gtlions60:gpadmin-[INFO]:-No standby master configured. skipping... 20141019:12:48:02:027904 gpstart:gtlions60:gpadmin-[INFO]:-Database successfully started 20141019:12:48:11:029041 gpstart:gtlions60:gpadmin-[INFO]:-Starting gpstart with args: -a -d /data/master/gpseg-1 20141019:12:48:11:029041 gpstart:gtlions60:gpadmin-[INFO]:-Gathering information and validating the environment... 20141019:12:48:11:029041 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1' 20141019:12:48:12:029041 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150' 20141019:12:48:12:029041 gpstart:gtlions60:gpadmin-[INFO]:-Starting Master instance in admin mode 20141019:12:48:13:029041 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20141019:12:48:13:029041 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Segment details from master... 20141019:12:48:13:029041 gpstart:gtlions60:gpadmin-[INFO]:-Setting new master era 20141019:12:48:13:029041 gpstart:gtlions60:gpadmin-[INFO]:-Master Started... 20141019:12:48:13:029041 gpstart:gtlions60:gpadmin-[INFO]:-Shutting down master 20141019:12:48:14:029041 gpstart:gtlions60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait... 20141019:12:48:16:029041 gpstart:gtlions60:gpadmin-[INFO]:-Process results... 20141019:12:48:16:029041 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:48:16:029041 gpstart:gtlions60:gpadmin-[INFO]:- Successful segment starts = 2 20141019:12:48:16:029041 gpstart:gtlions60:gpadmin-[INFO]:- Failed segment starts = 0 20141019:12:48:16:029041 gpstart:gtlions60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0 20141019:12:48:16:029041 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:48:16:029041 gpstart:gtlions60:gpadmin-[INFO]:- 20141019:12:48:16:029041 gpstart:gtlions60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances 20141019:12:48:16:029041 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:48:16:029041 gpstart:gtlions60:gpadmin-[INFO]:-Starting Master instance gtlions60 directory /data/master/gpseg-1 20141019:12:48:18:029041 gpstart:gtlions60:gpadmin-[INFO]:-Command pg_ctl reports Master gtlions60 instance active 20141019:12:48:18:029041 gpstart:gtlions60:gpadmin-[INFO]:-No standby master configured. skipping... 20141019:12:48:18:029041 gpstart:gtlions60:gpadmin-[INFO]:-Database successfully started 20141019:12:50:14:032393 gpstart:gtlions60:gpadmin-[INFO]:-Starting gpstart with args: -a 20141019:12:50:14:032393 gpstart:gtlions60:gpadmin-[INFO]:-Gathering information and validating the environment... 20141019:12:50:14:032393 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1' 20141019:12:50:14:032393 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150' 20141019:12:50:14:032393 gpstart:gtlions60:gpadmin-[WARNING]:-postmaster.pid file exists on Master, checking if recovery startup required 20141019:12:50:14:032393 gpstart:gtlions60:gpadmin-[INFO]:-Commencing recovery startup checks 20141019:12:50:14:032393 gpstart:gtlions60:gpadmin-[INFO]:-Have lock file /tmp/.s.PGSQL.5432 and a process running on port 5432 20141019:12:50:14:032393 gpstart:gtlions60:gpadmin-[ERROR]:-gpstart error: Master instance process running [gpadmin@gtlions60 ~]$ gpstop -a 20141019:12:52:42:032463 gpstop:gtlions60:gpadmin-[INFO]:-Starting gpstop with args: -a 20141019:12:52:42:032463 gpstop:gtlions60:gpadmin-[INFO]:-Gathering information and validating the environment... 20141019:12:52:42:032463 gpstop:gtlions60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20141019:12:52:42:032463 gpstop:gtlions60:gpadmin-[INFO]:-Obtaining Segment details from master... 20141019:12:52:42:032463 gpstop:gtlions60:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 4.3.3.1 build 1' 20141019:12:52:42:032463 gpstop:gtlions60:gpadmin-[INFO]:-There are 0 connections to the database 20141019:12:52:42:032463 gpstop:gtlions60:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart' 20141019:12:52:42:032463 gpstop:gtlions60:gpadmin-[INFO]:-Master host=gtlions60 20141019:12:52:42:032463 gpstop:gtlions60:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=smart 20141019:12:52:42:032463 gpstop:gtlions60:gpadmin-[INFO]:-Master segment instance directory=/data/master/gpseg-1 20141019:12:52:43:032463 gpstop:gtlions60:gpadmin-[INFO]:-No standby master host configured 20141019:12:52:43:032463 gpstop:gtlions60:gpadmin-[INFO]:-Commencing parallel segment instance shutdown, please wait... ... 20141019:12:52:46:032463 gpstop:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:52:46:032463 gpstop:gtlions60:gpadmin-[INFO]:- Segments stopped successfully = 2 20141019:12:52:46:032463 gpstop:gtlions60:gpadmin-[INFO]:- Segments with errors during stop = 0 20141019:12:52:46:032463 gpstop:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:52:46:032463 gpstop:gtlions60:gpadmin-[INFO]:-Successfully shutdown 2 of 2 segment instances 20141019:12:52:46:032463 gpstop:gtlions60:gpadmin-[INFO]:-Database successfully shutdown with no errors reported [gpadmin@gtlions60 ~]$ gpstart -a 20141019:12:52:50:032514 gpstart:gtlions60:gpadmin-[INFO]:-Starting gpstart with args: -a 20141019:12:52:50:032514 gpstart:gtlions60:gpadmin-[INFO]:-Gathering information and validating the environment... 20141019:12:52:50:032514 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1' 20141019:12:52:50:032514 gpstart:gtlions60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150' 20141019:12:52:50:032514 gpstart:gtlions60:gpadmin-[INFO]:-Starting Master instance in admin mode 20141019:12:52:51:032514 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20141019:12:52:51:032514 gpstart:gtlions60:gpadmin-[INFO]:-Obtaining Segment details from master... 20141019:12:52:51:032514 gpstart:gtlions60:gpadmin-[INFO]:-Setting new master era 20141019:12:52:51:032514 gpstart:gtlions60:gpadmin-[INFO]:-Master Started... 20141019:12:52:51:032514 gpstart:gtlions60:gpadmin-[INFO]:-Shutting down master 20141019:12:52:53:032514 gpstart:gtlions60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait... .. 20141019:12:52:55:032514 gpstart:gtlions60:gpadmin-[INFO]:-Process results... 20141019:12:52:55:032514 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:52:55:032514 gpstart:gtlions60:gpadmin-[INFO]:- Successful segment starts = 2 20141019:12:52:55:032514 gpstart:gtlions60:gpadmin-[INFO]:- Failed segment starts = 0 20141019:12:52:55:032514 gpstart:gtlions60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0 20141019:12:52:55:032514 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:52:55:032514 gpstart:gtlions60:gpadmin-[INFO]:- 20141019:12:52:55:032514 gpstart:gtlions60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances 20141019:12:52:55:032514 gpstart:gtlions60:gpadmin-[INFO]:----------------------------------------------------- 20141019:12:52:55:032514 gpstart:gtlions60:gpadmin-[INFO]:-Starting Master instance gtlions60 directory /data/master/gpseg-1 20141019:12:52:56:032514 gpstart:gtlions60:gpadmin-[INFO]:-Command pg_ctl reports Master gtlions60 instance active 20141019:12:52:56:032514 gpstart:gtlions60:gpadmin-[INFO]:-No standby master configured. skipping... 20141019:12:52:56:032514 gpstart:gtlions60:gpadmin-[INFO]:-Database successfully started
-EOF-
博肯 推荐喂养等级:★★★★
【好感也吃铁片和砥石,普通也吃无色。抗性药可以用魔li之语代替】
普通-好感-信赖,回馈物品和喂养材料的分别是
璀璨玫瑰、蜂蜜 鲸须、猛兽的利齿 龙之心
(碳、无色、砥石) (碳、砥石、铁片) (抗性药、魔li之语)
讨厌:碎骨
可以信赖,入手龙之心。
★P.S.
想直接卖材料的,在推荐等级四星和五星之间选择NPC喂吧。想做炼金药的就自己选择一下吧。
至于为什么没有2星和1星呢,是因为我觉得星星多了比较好看= =一般不都是5星算是满分么.....
☆另一个P.S.
我发的NPC分析的顺序,也是我喂NPC的大致路线...
艾丽丝 推荐喂养等级:★★★
【抗性药可以用魔力之语代替】
普通-好感-信赖,回馈物品和喂养材料的分别是
营养蘑菇、璀璨玫瑰 魔法珍珠、辣椒 怪异的蛋
(抗性药、魔力之语) (抗性药、魔力之语) (抗性药、魔力之语)
讨厌:破旧的皮革
玫瑰和珍珠可以做魔力结晶。蛋的价格还不错。
莎兰 推荐喂养等级:★★★★★
【除了小无色,也吃下级元素结晶和暗符咒】
普通-好感-信赖,回馈物品和喂养材料的分别是
蜂蜜、璀璨玫瑰 白萝卜、黑橡果 鹳的翅膀
(无色、下级元素、暗符咒) (无色、下级元素、暗符咒) (无色、暗符咒)
讨厌:坚韧的触须
暂时没有必要信赖,好感就好。鹳的翅膀是疲劳药和瞬移药的材料,目前还米有用。蜂蜜和白萝卜无论是自己用还是卖掉都很合算。
马琳·基希卡 推荐喂养等级:★★★★
【抗性药可以用魔力之语代替,讨厌皮革、碎骨、硬化剂】
普通-好感-信赖,回馈物品和喂养材料的分别是
蜂蜜、魔法珍珠 郁金香、木瓜 神之印章
(炉岩碳) (抗性药、魔力之语) (抗性药、魔力之语、皮革)
讨厌:皮革、硬化剂,貌似碎骨也可以
蜂蜜和木瓜卖材料很好卖。
沙影贝利特 推荐喂养等级:★★★★★
普通-好感-信赖,回馈物品和喂养材料的分别是
天然奶酪、香霉菌 野山参、白萝卜 海龟壳
(无色、皮革、碎骨) (无色) (无色)
讨厌:硬化剂、溶解剂(硬化剂 和 溶解剂 总是可以互相替代的)
白萝卜和海龟壳的好来源,这么好养活的沙影,不信赖还等什么= =
梅尔文·里克特 推荐喂养等级:★★★★
【信赖除了碳,也吃铁片和最下级砥石。讨厌皮革】
普通-好感-信赖,回馈物品和喂养材料的分别是
野山参、璀璨玫瑰 木瓜、鲸须 百年人参
(碳、下级元素) (碳、砥石、铁片) (碳、砥石、铁片)
讨厌:皮革
可以信赖,百年野参价格不算高,卖掉或自用都可以。木瓜和野山参可以卖掉。
泽丁·施奈德 推荐喂养等级:★★★
【好感时碎骨和铁片都可以,信赖只吃碎骨(别的暂时没发现)】
普通-好感-信赖,回馈物品和喂养材料的分别是
蜂蜜、魔法珍珠 五彩珊瑚、怪异的蛋 鹤的翅膀
(碎骨、铁片) (碎骨、铁片) (碎骨)
讨厌:硬化剂、溶解剂
没有必要信赖,好感就可以。蜂蜜和蛋可以卖掉,珊瑚做智力药。
赛丽亚 推荐喂养等级:★★★......余下全文>>
自己找个旗舰版的镜像安装,激活搜个OEM码就是。