|
]$ gpstart -a
20141020:10:44:09:003808 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a
20141020:10:44:09:003808 gpstart:wx60:gpadmin-[INFO]:-Gathering information and validating the environment...
20141020:10:44:09:003808 gpstart:wx60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.2.7.2 build 1'
20141020:10:44:10:003808 gpstart:wx60:gpadmin-[INFO]:-Greenplum Catalog Version: '201109210'
20141020:10:44:10:003808 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance in admin mode
20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Obtaining Segment details from master...
20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Setting new master era
20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Master Started...
20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Shutting down master
20141020:10:44:12:003808 gpstart:wx60:gpadmin-[INFO]:-No standby master configured. skipping...
20141020:10:44:12:003808 gpstart:wx60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
..
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-Process results...
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:- Successful segment starts = 2
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 0
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance wx60 directory /data/gp/master/gpseg-1
20141020:10:44:15:003808 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active
20141020:10:44:16:003808 gpstart:wx60:gpadmin-[INFO]:-Database successfully started
[gpadmin@wx60 ~]$ ll
总计 20
drwxrwxr-x 2 gpadmin gpadmin 4096 08-29 09:44 gp
drwxrwxr-x 2 gpadmin gpadmin 4096 10-20 10:28 gpAdminLogs
drwxrwxr-x 2 gpadmin gpadmin 4096 10-20 10:24 gpcheckcat.repair.2014-10-20.10.22.34
drwxrwxr-x 3 gpadmin gpadmin 4096 10-20 10:42 gpcheckcat.repair.2014-10-20.10.32.12
drwxrwxr-x 2 gpadmin gpadmin 4096 08-29 09:45 gpconfigs
[gpadmin@wx60 ~]$ sh gpcheckcat.repair.2014-10-20.10.32.12/runsql.sh
Dropping temporary schemas
[gpadmin@wx60 ~]$ cd gpcheckcat.repair.2014-10-20.10.32.12
[gpadmin@wx60 gpcheckcat.repair.2014-10-20.10.32.12]$ cat runsql.sh
#!/bin/bash
cd $(dirname $0)
echo "Dropping temporary schemas"
psql -X -a -h wx60 -p 5432 -f fixnamespace.sql "gtlions" > fixnamespace.sql.out 2>&1
[gpadmin@wx60 gpcheckcat.repair.2014-10-20.10.32.12]$ psql -X -a -h wx60 -p 5432 -f fixnamespace.sql "gtlions"
DROP SCHEMA IF EXISTS "pg_temp_54" CASCADE;
psql:fixn |