gpsscli stop

A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 6.x documentation.

gpsscli stop

Stop a ?running? Greenplum Stream Server job.


gpsscli stop job_name
     [--quit-at-eof] [--gpss-host host] [--gpss-port port]
     [-l | --log-dir directory] [-v | --verbose]

gpsscli stop {-h | --help}


The gpsscli stop command stops a job submitted to a specific Greenplum Stream Server (GPSS) instance.

When you stop a job, GPSS writes any batched data to Greenplum Database and stops actively reading new data from the data source. The job transitions from the Running to the Stopped state.

If the gpss instance servicing the job is configured to not reuse external tables (ReuseTables: false), or the job was started with the --no-reuse option, gpsscli stop also drops the external table currently associated with the job.

If the GPSS instance to which you want to send the request is not running on the default host ( or the default port number (5000), you can specify the GPSS host and/or port via command line options.


The identifier of a previously-submitted GPSS job. You can specify a job name when you run gpsscli submit, or the command returns a unique job identifier.
When you specify this option, gpsscli stop reads data until it receives an EOF, then stops the job and exits. The default behaviour of gpsscli stop is to immediately write any unwritten batched data before stopping the job and exiting.
--gpss-host host
Specify the GPSS host. The default host address is
--gpss-port port
Specify the GPSS port number. The default port number is 5000.
-l | --log-dir directory
Specify the directory to which GPSS writes client command log files. GPSS must have write permission to the directory. GPSS creates the log directory if it does not exist.
If you do not provide this option, GPSS writes gpsscli client log files to the $HOME/gpAdminLogs directory.
-v | --verbose
The default behaviour of the command utility is to display information and error messages to stdout. When you specify the --verbose option, GPSS also outputs debug-level messages about the operation.
-h | --help
Show command utility help, and then exit.


Stop the GPSS job identified by the name nsync_121118:

$ gpsscli stop nsync_121118