Send netdisco-users mailing list submissions to
netdisco-users@lists.sourceforge.net
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
netdisco-users-requ...@lists.sourceforge.net
You can reach the person managing the list at
netdisco-users-ow...@lists.sourceforge.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. Re: Exported and Restored database on a new server and got
these errors if deploying again (Christian Ramseyer)
--- Begin Message ---
Hi
On 03.04.2025 16:53, Basti S. wrote:
Hello,
I have created a dump on my Netdisco machine with
/pg_dump netdisco > netdisco.dump/
and restored it the following way on a new Netdisco installation:
/psql -U postgres -d postgres -c "DROP DATABASE netdisco;"
psql -U postgres -d postgres -c "CREATE DATABASE netdisco;"
psql -U postgres -d netdisco -f ../../../tmp/netdisco.dump/
Afterwards I deployed Netdisco again and get the following errors:
/Download and update vendor MAC prefixes (OUI data)? [y/N]: y
Updating OUI, Manufacturers, Enterprises, and Products... psql:/home/
netdisco/netdisco-lookup-tables.sql:33854: ERROR: relation "enterprise"
does not exist
LINE 1: DELETE FROM "enterprise";
The enterprise table is somewhat new, it looks like the new version you
downloaded expects it but somehow failed to create it.
If you do netdisco-deploy, in the frist schema upgrade part, are there
any errors or does it show a successful upgrade to the latest schema
version (93 or so)?
In case you redo the dump, it's best using e.g.
pg_dump -c -d netdisco -C --format=p
then the create database and drop/redo of objects makes sure you have a
clean slate.
Cheers
Christian
--
Christian Ramseyer, netnea ag
Network Management. Security. OpenSource.
https://www.netnea.com
Phone: +41 79 644 77 64
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users
