lc_monetary = 'en_US.utf8' # inserted by initdb
lc_numeric = 'en_US.utf8' # inserted by initdb
lc_time = 'en_US.utf8' # inserted by initdb
gp_resqueue_memory_policy = 'eager_free' # memory request based queueing.
# eager_free, auto or none
s
max_appendonly_tables = 10000 # Maximum number of append only tables that can
# participate in writing data concurrently.
gp_interconnect_type=udpifc
# - Worker Process Creation -
gp_connections_per_thread = 64
gp_segment_connect_timeout = 600s
gp_vmem_protect_limit = 8192 #Virtual memory limit (in MB).
gp_backup_directIO = off # enable\disable dump with direct IO
gp_backup_directIO_read_chunk_mb = 20 # Size of read Chunk buffer in directIO dump (in MB)
gp_crash_handler_async = on
#Greenplum specific configuration parameters for Master instance database
log_statement=all
checkpoint_segments=8
Segment节点核心信息：
# - Connection Settings -
listen_addresses='*' ##listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to '*', '*' = all
# (change requires restart)
port=40000 ##port = 5432 # sets the database listener port for
# a Greenplum instance. The master and
# each segment has its own port number.
max_connections = 750 # inserted by initdb默认是主节点的三倍
# - Memory -
shared_buffers = 125MB # inserted by initdb
#shared_buffers = 128MB # min 128kB or max_connections*16kB
# (change requires restart)
#temp_buffers = 8MB # min 800kB
max_prepared_transactions = 250 # can be 0 or more
# (change requires restart)
# - Free Space Map -
max_fsm_pages = 200000 # inserted by initdb
gp_autostats_mode=on_no_stats # none, on_no_stats, on_change. see documentation for semantics.
gp_autostats_on_change_threshold=2147483647 # [0..INT_MAX]. see documentation for semantics.
log_autostats=off # print additional autostats information
0
# - Locale and Formatting -
datestyle = 'iso, mdy' # inserted by initdb
# These settings are initialized by initdb, but they can be changed.
lc_messages = 'en_US.utf8' # inserted by initdb
lc_monetary = 'en_US.utf8' # inserted by initdb
lc_numeric = 'en_US.utf8' # inserted by initdb
lc_time = 'en_US.utf8' # inserted by initdb
gp_resqueue_memory_policy = 'eager_free' # memory request based queueing.
# eager_free, auto or none
max_appendonly_tables = 10000 # Maximum number of append only tables that can
# participate in writing data concurrently.
#gp_max_packet_size = 8192
gp_interconnect_type=udpifc
# - Worker Process Creation -
gp_connections_per_thread = 64
gp_segment_connect_timeout = 600s
#gp_enable_delete_as_truncate = off
# - Resource limits -
gp_vmem_protect_limit = 8192 #Virtual memory limit (in MB).
#custom_variable_classes = '' # list of custom variable class names
gp_backup_directIO = off # enable\disable dump with direct IO
gp_backup_directIO_read_chunk_mb = 20 # Size of read Chunk buffer in directIO dump (in MB)
gp_crash_handler_async = on
#MPP Specific parameters
#----------------------
checkpoint_segments=8
配置过程中出现如下错误：
| Command was: 'env GPSESSID=0000000000 GPERA=None $GPHOME/bin/pg_ctl -D /data/master/gpseg-1 -l /data/master/gpseg-1/pg_log/startup.log -w -t 600 -o " -p 5432 -b 1 -z 0 --silent-mode=true -i -M master -C -1 -x 0 -c gp_role=utility " start' rc=1, stdout='waiting for server to start......could not start server ', stderr='pg_ctl: PID file "/data/master/gpseg-1/postmaster.pid" does not exist |
解决方案：
在GP_master上重启服务即可。