Pivotal Knowledge Base

Follow

How to Dump Resource Queue Information Using pg_dumpall

Environment

Pivotal Greenplum Database (GPDB) all versions

Purpose

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.

Procedure

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

Comments

Powered by Zendesk