Send netdisco-users mailing list submissions to
        [email protected]

To subscribe or unsubscribe via the World Wide Web, visit
        https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
        [email protected]

You can reach the person managing the list at
        [email protected]

When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:

   1. Migrating a database (Johnnie Adams)
   2. Re: Migrating a database (Basti S.)
--- Begin Message ---
Hi, folks,

     I recently was asked to migrate a NetDisco instance. I built a new
instance, added a couple of users, and all looked well. Then I imported--or
tried to--the data. The load appears to have failed.

     Is there a particular place in the build of the new instance when the
old data should be loaded?

Thanks,

     John A

--- End Message ---
--- Begin Message ---
Hi John,

We make it this way:

Very important: Update the current Netdisco instance to the same version as
the new one!!

Create database backup on the current Netdisco VM

Stop the Netdisco services
Dump the database
~/bin/netdisco-web stop ~/bin/netdisco-backend stop pg_dump -U netdisco -h
localhost -c -Fc netdisco > netdisco.dump


Transfer the dump file to the new machine, for example with WinSCP
File location: /tmp/netdisco.dump


Import the dump on the new Netdisco instance

Stop the Netdisco services
Drop the current Netdisco database

Create a new Netdisco database
Restore the database dump file to the new database

sudo su - postgres psql -U postgres -d postgres -c "DROP DATABASE netdisco;"

psql -U postgres -d postgres -c "CREATE DATABASE netdisco;"
pg_restore -d netdisco ../../../tmp/netdisco.dump

exit

Regards,
Bastian


Am Fr., 17. Apr. 2026 um 02:13 Uhr schrieb Johnnie Adams <[email protected]>:

> Hi, folks,
>
>      I recently was asked to migrate a NetDisco instance. I built a new
> instance, added a couple of users, and all looked well. Then I imported--or
> tried to--the data. The load appears to have failed.
>
>      Is there a particular place in the build of the new instance when the
> old data should be loaded?
>
> Thanks,
>
>      John A
> _______________________________________________
> Netdisco mailing list
> [email protected]
> https://sourceforge.net/p/netdisco/mailman/netdisco-users/

--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users

Reply via email to