Pivotal Knowledge Base

Follow

How to dump resource queue information using pg_dumpall

Problem

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.

Solution

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