Greenplum管理表空间Tablespace(五)
ocations for all components
in a Greenplum system (primary segment, mirror segment and master instances).
Once a filespace is created, it can be used by one or more tablespaces.
20130418:16:36:34:007937 gpfilespace:o564gtser1:gpadmin-[INFO]:-Getting filespace information for TRANSACTION_FILES
20130418:16:36:34:007937 gpfilespace:o564gtser1:gpadmin-[INFO]:-Checking for filespace consistency
20130418:16:36:34:007937 gpfilespace:o564gtser1:gpadmin-[INFO]:-Obtaining current filespace entries used by TRANSACTION_FILES
20130418:16:36:35:007937 gpfilespace:o564gtser1:gpadmin-[INFO]:-TRANSACTION_FILES OIDs are consistent for pg_system filespace
20130418:16:36:36:007937 gpfilespace:o564gtser1:gpadmin-[INFO]:-TRANSACTION_FILES entries are consistent for pg_system filespace
20130418:16:36:36:007937 gpfilespace:o564gtser1:gpadmin-[INFO]:-Obtaining current filespace entries used by TRANSACTION_FILES
20130418:16:36:36:007937 gpfilespace:o564gtser1:gpadmin-[INFO]:-Current Filespace for TRANSACTION_FILES is pg_system
20130418:16:36:36:007937 gpfilespace:o564gtser1:gpadmin-[INFO]:-1 /data/master/gtgpseg-1
20130418:16:36:36:007937 gpfilespace:o564gtser1:gpadmin-[INFO]:-2 /data/primary/gtgpseg0
20130418:16:36:36:007937 gpfilespace:o564gtser1:gpadmin-[INFO]:-3 /data/primary/gtgpseg1
[gpadmin@o564gtser1 ~]$ gpfilespace --showtempfilespace
20130418:16:36:41:008196 gpfilespace:o564gtser1:gpadmin-[INFO]:-
A tablespace requires a file system location to store its database
files. A filespace is a collection of file system locations for all components
Once a filespace is created, it can be used by one or more tablespaces.
20130418:16:36:41:008196 gpfilespace:o564gtser1:gpadmin-[INFO]:-Getting filespace information for TEMPORARY_FILES
20130418:16:36:41:008196 gpfilespace:o564gtser1:gpadmin-[INFO]:-Checking for filespace consistency
20130418:16:36:41:008196 gpfilespace:o564gtser1:gpadmin-[INFO]:-Obtaining current filespace entries used by TEMPORARY_FILES
20130418:16:36:42:008196 gpfilespace:o564gtser1:gpadmin-[INFO]:-TEMPORARY_FILES OIDs are consistent for pg_system filespace
20130418:16:36:43:008196 gpfilespace:o564gtser1:gpadmin-[INFO]:-TEMPORARY_FILES entries are consistent for pg_system filespace
20130418:16:36:43:008196 gpfilespace:o564gtser1:gpadmin-[INFO]:-Obtaining current filespace entries used by TEMPORARY_FILES
20130418:16:36:43:008196 gpfilespace:o564gtser1:gpadmin-[INFO]:-Current Filespace for TEMPORARY_FILES is pg_system
20130418:16:36:43:008196 gpfilespace:o564gtser1:gpadmin-[INFO]:-1 /data/master/gtgpseg-1
20130418:16:36:43:008196 gpfilespace:o564gtser1:gpadmin-[INFO]:-2 /data/primary/gtgpseg0
20130418:16:36:43:008196 gpfilespace:o564gtser1:gpadmin-[INFO]:-3 /data/primary/gtgpseg1
[gpadmin@o564gtser1 ~]$ gpfilespace --movetransfilespace gtlionsfilespace
20130418:16:37:37:008477 gpfilespace:o564gtser1:gpadmin-[INFO]:-
A tablespace requires a file system location to store its database
files. A filespace is a collection of file system locations for all components
in a Greenplum system (primar