Netbox database backup and restore preserving users, groups and permissions.

[jeschebach]

Hi folks, what is the best way to perform a complete database backup excluding users, notifications, plugin related data?
The idea is to restore information from one environment into another, preserving existing users, groups and permissions in the destination.

Both origin and destination run Netbox v4.1.4 and PostgreSQL 17

I'm planning using pg_dump / pg_restore to achieve this, and would like to know which tables should I not include in the backup in order to avoid errors when restoring.

Any help would be highly appreciated!!

[a084ed22]

Users are stored in their own table, so you can simply not restore that, but I'd advise against this as you need to be aware of what references what at database level to not create inconsistencies. Fundamentally, this is unsupported.