Greenplum Streaming Server (GPSS) code must be upgraded along with Greenplum Database (GPDB)

Products

• VMware Tanzu Greenplum

Issue/Introduction

There are two important rules for Greenplum Streaming Server (GPSS), these rules are that:

1. The GPSS and Greenplum Database (GPDB) version must be the exact same or match each other. With this rule, when you upgrade the GPDB, you must upgrade the ETL server's GPSS as well.

2. After upgrading the GPDB to a newer version, you must drop the GPSS extension and re-create it in the new GPDB code.

Environment

Product Version: Other

Resolution

For rule 1 mentioned above, where the GPDB and GPSS versions must match, the way to check if this is the case is by doing the following:

1. On ETL server that runs gpss:

$ gpss version

2. On master from psql:

$ select gpfmt_version();

For the rule 2 mentioned above, to drop the GPSS extension and re-create it in the new GPDB code, do the following:

gpadmin=# DROP EXTENSION gpss;

DROP EXTENSION

gpadmin=# CREATE EXTENSION gpss;

CREATE EXTENSION