Stop one or more Greenplum Streaming Server jobs.


gpsscli stop {<job_name> | <job_id>}
     [--all] [--quit-at-eof]
     [--config <gpsscliconfig.json>]
     [--gpss-host <host>] [--gpss-port <port>]
     [-U | --username <client_auth_user> -P | --password <client_auth_passwd>]
     [--no-check-ca] [-l | --log-dir <directory>] [--verbose]

gpsscli stop {-h | --help}


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

Specify the --all flag to the command to stop all running jobs.

When you stop a running 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), 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.


job_name | job_id
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.
Stop all currently running jobs.
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.
--config gpsscliconfig.json

The GPSS configuration file. This file includes properties that identify the gpss instance that services the command. When SSL encryption is enabled between the GPSS client and server, you also use this file to identify the file system location of the client SSL certificates. Refer to gpss.json for detailed information about the format of this file and the configuration properties supported.


gpsscli subcommands read the configuration specified in the ListenAddress block of the gpsscliconfig.json file, and ignore the gpfdist configuration specified in the Gpfdist block of the file.


Enable the use of color when displaying front-end log messages. When specified, GPSS colors the log level in messages that it writes to stdout. Color is deactivated by default.

GPSS ignores the --color option if you also specify --csv-log.
Write front-end log messages in CSV format. By default, GPSS writes log messages to stdout using spaces between fields for a more human-readable format.
--gpss-host host
The GPSS host. The default host address is If specified, overrides a ListenAddress:Host value provided in gpsscliconfig.json
--gpss-port port
The GPSS port number. The default port number is 5000. If specified, overrides a ListenAddress:Port value provided in gpsscliconfig.json
Deactivate certificate verification when SSL is enabled between the GPSS client and server. By default, GPSS checks the certificate authority (CA) each time that you invoke a gpsscli subcommand.
-U | --username client_auth_username
The user name with which the GPSS server instance authenticates the client.
-P | --password client_auth_passwd
The password with which the GPSS server instance authenticates the client.
-l | --log-dir directory

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.
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

See Also

gpss, gpsscli list, gpsscli submit

check-circle-line exclamation-circle-line close-line
Scroll to top icon