nautobot-server dumpdata ; Unable to serialize database

[jifox]

Environment

• Python version: 3.8.10
• Nautobot version: v1.1.4

Steps to Reproduce

1. start "nautobot-server dumpdata > output.txt

Expected Behavior

All data is dumped

Observed Behavior

CommandError: Unable to serialize database: cursor "_django_curs_140149812463424_sync_97" does not exist

[glennmatthews]

Thanks for the report! Due to details of Nautobot's database model, there are several tables you presently need to exclude from the dump and several others you may wish to exclude as well. Specifically, at a minimum you will need --exclude extras.job.

See https://nautobot.readthedocs.io/en/latest/installation/migrating-from-postgresql/#export-data-from-postgresql for a recommended complete dumpdata command. I recognize that this page in the docs is not easily discoverable at the moment - if there are other doc pages where it would be helpful to link to this from, a documentation update pull request would be more than welcome!

[jifox]

Thanks @glennmatthews

Following the description the export / import was successful

[jifox]

I think the The Nautobot Server Command page will be a good place for referencing the dumpdata and loaddata command

https://nautobot.readthedocs.io/en/latest/administration/nautobot-server/#the-nautobot-server-command