Pivotal Knowledge Base


How to dump resource queue information using pg_dumpall


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.


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


Powered by Zendesk