Migration Steps missing #922

New Issue

adam · 2025-12-29T16:27:00+01:00

adam commented

2025-12-29 16:27:00 +01:00

Originally created by @claughinghouse on GitHub (May 8, 2017).

Issue type:

Missing documentation.

**NetBox version: All
Markup page is below.

Migration from one host to another

Dump the database by first su to postgres user on the current netbox server

# pg_dump netbox > netbox_db.bak

Copy the netbox_db.bak file from /var/lib/psql directory to the new machine.

On the new machine initialize a new database and netbox user with the same database password as before.

# sudo -u postgres psql
psql (9.3.13)
Type "help" for help.

postgres=# CREATE DATABASE netbox;
CREATE DATABASE
postgres=# CREATE USER netbox WITH PASSWORD 'J5brHrAXFLQSif0K';
CREATE ROLE
postgres=# GRANT ALL PRIVILEGES ON DATABASE netbox TO netbox;
GRANT
postgres=# \q

You can verify that authentication works issuing the following command and providing the configured password:

# psql -U netbox -h localhost -W

If successful, you will enter a postgres prompt. Type \q to exit.

Copy the netbox_db.bak file on the new to host to /var/lib/pgsql

Become the user and import the database

# pg_dump netbox < netbox_db.bak

Originally created by @claughinghouse on GitHub (May 8, 2017). ### Issue type: Missing documentation. **NetBox version: All Markup page is below. ## Migration from one host to another Dump the database by first `su` to postgres user on the current netbox server ```# sudo su - postgres # pg_dump netbox > netbox_db.bak ``` Copy the netbox_db.bak file from `/var/lib/psql` directory to the new machine. On the new machine initialize a new database and netbox user with the same database password as before. ```no-highlight # sudo -u postgres psql psql (9.3.13) Type "help" for help. postgres=# CREATE DATABASE netbox; CREATE DATABASE postgres=# CREATE USER netbox WITH PASSWORD 'J5brHrAXFLQSif0K'; CREATE ROLE postgres=# GRANT ALL PRIVILEGES ON DATABASE netbox TO netbox; GRANT postgres=# \q ``` You can verify that authentication works issuing the following command and providing the configured password: ```no-highlight # psql -U netbox -h localhost -W ``` If successful, you will enter a postgres prompt. Type `\q` to exit. Copy the netbox_db.bak file on the new to host to `/var/lib/pgsql` Become the user and import the database ```# sudo su - postgres # pg_dump netbox < netbox_db.bak ```

adam closed this issue

2025-12-29 16:27:00 +01:00

adam commented

2025-12-29 16:27:01 +01:00

@jeremystretch commented on GitHub (May 8, 2017):

You're describing the process of replicating a PostgreSQL database, which is well-defined elsewhere and is not specific to NetBox. There's no reason to include it in our documentation.

@jeremystretch commented on GitHub (May 8, 2017): You're describing the process of replicating a PostgreSQL database, which is well-defined elsewhere and is not specific to NetBox. There's no reason to include it in our documentation.

Sign in to join this conversation.

Branches Tags

main

update-changelog-comments-docs

feature-removal-issue-type

20911-dropdown

20239-plugin-menu-classes-mutable-state

21097-graphql-id-lookups

feature

fix_module_substitution

20923-dcim-templates

20044-elevation-stuck-lightmode

feature-ip-prefix-link

v4.5-beta1-release

20068-import-moduletype-attrs

20766-fix-german-translation-code-literals

20378-del-script

7604-filter-modifiers-v3

circuit-swap

12318-case-insensitive-uniqueness

20637-improve-device-q-filter

20660-script-load

19724-graphql

20614-update-ruff

14884-script

02496-max-page

19720-macaddress-interface-generic-relation

19408-circuit-terminations-export-templates

20203-openapi-check

fix-19669-api-image-download

7604-filter-modifiers

19275-fixes-interface-bulk-edit

fix-17794-get_field_value_return_list

11507-show-aggregate-and-rir-on-api

9583-add_column_specific_search_field_to_tables

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/netbox#922