Dump resource queue information using pg_dumpall

Products

• VMware Tanzu Greenplum

Issue/Introduction

pg_dumpall is a utility which dumps the Greenplum database including global objects that are common to all databases, but when you look at the output generated by pg_dumpall you might encounter that the resource queue information is missing.

Environment

Pivotal Greenplum Database (GPDB) all versions

Resolution

In order to include the resource queue details in pg_dumpall output, you would have to add the parameter "--resource-queues" along with the command.

So, the command would look like:

pg_dumpall --resource-queues