starred/netbox
1
0
Fork 0
mirror of https://github.com/netbox-community/netbox.git synced 2026-01-11 21:10:29 +01:00
Code Issues 273 Packages Projects Releases 10 Wiki Activity

Migration of pgsql django.db.utils.ProgrammingError: permission denied for table django_migrations #7338

New Issue
Closed
opened 2025-12-29 20:22:05 +01:00 by adam · 0 comments
adam commented 2025-12-29 20:22:05 +01:00
Owner
Copy Link

Originally created by @atdcode on GitHub (Dec 9, 2022).

NetBox version

3.3.9

Python version

3.9

Steps to Reproduce

  1. After a fresh install of netbox 3.3.9 on debian 11 with pgsql (14.6-1.pgdg110+1)
  2. sudo -u postgres psql -c 'drop database netbox'
  3. sudo -u postgres psql -c 'drop database netbox'
  4. sudo -u postgres psql -c 'grant all privileges on database netbox to netbox
  5. sudo -u postgres psql netbox < my_pgsql14_netbox.sql
  6. source /opt/netbox/venv/bin/activate
  7. cd /opt/netbox/netbox
  8. python3 manage.py migrate
  9. django.db.utils.ProgrammingError: permission denied for table django_migrations

Expected Behavior

a clean import

Observed Behavior

Trying to import a pgsql 14 database in a fresh install of netbox.

Originally created by @atdcode on GitHub (Dec 9, 2022). ### NetBox version 3.3.9 ### Python version 3.9 ### Steps to Reproduce 1. After a fresh install of netbox 3.3.9 on debian 11 with pgsql (14.6-1.pgdg110+1) 2. sudo -u postgres psql -c 'drop database netbox' 3. sudo -u postgres psql -c 'drop database netbox' 4. sudo -u postgres psql -c 'grant all privileges on database netbox to netbox 5. sudo -u postgres psql netbox < my_pgsql14_netbox.sql 6. source /opt/netbox/venv/bin/activate 7. cd /opt/netbox/netbox 8. python3 [manage.py](https://manage.py/) migrate 9. django.db.utils.ProgrammingError: permission denied for table django_migrations ### Expected Behavior a clean import ### Observed Behavior Trying to import a pgsql 14 database in a fresh install of netbox.
adam closed this issue 2025-12-29 20:22:05 +01:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
beta
breaking change
complexity: high
complexity: low
complexity: medium
needs milestone
netbox
pending closure
plugin candidate
pull-request
Mirrored from GitHub Pull Request
 severity: high
severity: low
severity: medium
status: accepted
status: backlog
status: blocked
status: duplicate
status: needs owner
status: needs triage
status: revisions needed
status: under review
topic: GraphQL
topic: Internationalization
topic: OpenAPI
topic: UI/UX
topic: cabling
topic: event rules
topic: htmx navigation
topic: industrialization
topic: migrations
topic: plugins
topic: scripts
topic: templating
topic: testing
type: bug
type: deprecation
type: documentation
type: feature
type: housekeeping
type: translation
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
adam
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#7338
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?