SettingsPostgreSQL-server (Number Generator)
Install and configure the PostgreSQL database in which the Number Generator stores its numbers.
Video
▶
Video coming soon
A short explainer video will appear here
What this tool does
The Number Generator stores its number sequences in a PostgreSQL database. So you need one running server that every workstation can reach: locally for a single PC, or on an always-on server or PC for a team. The add-in creates the table Toolbox_NumberGenerator itself — you do not have to build any tables.
How to use it
- Install PostgreSQL from postgresql.org/download/windows. Remember the password for the postgres superuser and leave the port at 5432.
- Optional: use pgAdmin to create your own database (for example thundercad). By default the add-in uses the postgres database and the postgres user.
- For a team: open up the listen addresses in postgresql.conf, add your office network to pg_hba.conf, restart the postgresql service, and open port 5432 (TCP) in the firewall.
- Connect in Inventor via Settings → Number Generator: fill in host, port, database, user and password and click Check connection. That tests the connection and creates the table right away.
Settings
The Toolbox_NumberGenerator table
Created automatically on Check connection; this is the schema if you want to create or verify it manually.
name
TEXT PRIMARY KEY — the name of the sequence (for example P- or PART).
kolom
current_number
INTEGER NOT NULL — the last number issued for that sequence.
kolom
Tips
💡
Put the server on a PC that stays on; if the database is unreachable you cannot draw numbers (times out after 5 seconds).
💡
Use a strong password and open port 5432 only to your own network, never to the internet. Keep a backup of the database, as it holds all the numbers you have issued.
Try this tool yourself, free for 30 days
The full toolbox, no payment details needed. Works with Inventor 2025 and higher.