gprestore error - gpfmt_gpss.so file missing

[Jacques Blaauw]

I'm performing a gprestore on Linux RHEL 7 and I'm getting the following error:

Greenplum Database Restore Report

timestamp key: 20231207163727
gpdb version: 6.25.3 build commit:367edc6b4dfd909fe38fc288ade9e294d74e3f9a Open Source
gprestore version: 1.30.3

database name: Not Applicable
command line: gprestore --backup-dir /data/backup/ --timestamp 20231207163727

backup segment count: 8
restore segment count: 8
start time: Tue Jan 16 2024 16:21:49
end time: Tue Jan 16 2024 16:21:50
duration: 0:00:01

restore status: Failure
restore error: ERROR: could not access file "$libdir/gpfmt_gpss.so": No such file or directory (SQLSTATE 58P01)

Below is what I could find on the error code:

Class 58 — System Error (errors external to PostgreSQL itself)
58000 system_error
58030 io_error
58P01 undefined_file

When searching for the filename (gpfmt_gpss.so) in question I do not find any details.

Does anyone know what library this file is from and how I can install in on my system?

[Rui Zhao]

"gpfmt_gpss.so" is one of the .so files needed for GPSS(gp-stream-server) extension which is available for commercial customers.

This electronic communication and the information and any files transmitted with it, or attached to it, are confidential and are intended solely for the use of the individual or entity to whom it is addressed and may contain information that is confidential, legally privileged, protected by privacy laws, or otherwise restricted from disclosure to anyone else. If you are not the intended recipient or the person responsible for delivering the e-mail to the intended recipient, you are hereby notified that any use, copying, distributing, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error, please return the e-mail to the sender, delete it from your computer, and destroy any printed copy of it.

[Yongtao Huang]

Hi,

gpfmt_gpss is an extension of gp-streaming-server (gpss). 

here is the doc link https://docs.vmware.com/en/VMware-Greenplum-Streaming-Server/index.html

gpss is not open-source, and can only be used by customers who buy licenses.

If you install gpss, the extension gpss will automatically installed in the path of gpdb.

I hope this information can help you.

Best wishes

Yongtao Huang

On Fri, Jan 19, 2024 at 2:52 PM Jacques Blaauw <jacques...@gmail.com> wrote:

[Karen Huddleston]

Additionally, gprestore does not manage extra files on the file system that might be needed for extensions, we just back up and restore the objects in the database. If this is a new greenplum instance you may need to do work to ensure gpss is installed correctly in the destination system.