Multi-user storage

This type of storage can be used by many users with different levels of access. Data stability is improved and the app becomes more flexible.

Before creating multi-user storage, install a PostgreSQL database (next) or ensure that the installed version meets the minimum TNI requirements.

PostgreSQL installation for the first time

Download and install the latest version of PostgreSQL for Windows:

When installing a PostgreSQL database, you can accept all the default settings if there are no special requirements for its operation in your environment (for example, port 5432 for connecting to the database is by default already occupied by another service installed on the system).

During the installation process, you will also be required to enter the superuser (postgres) administrator password.

Once the PostgreSQL installation is complete, you can uncheck the box to run the Stack Builder settings, since this feature is not necessary for the database to operate properly.

If you plan to use the database for remote connections, then you will need to open the port specified during installation in your firewall, and also give permission to the necessary IP or IP address masks for your network in the pg_hba.conf file in the PostgreSQL installation folder.

Multiuser storage creation

While creating a new multi-user storage select a Create new storage option.

Create a new storage in the default folder or select an existing one to continue.

When creating a new storage make sure that all users in your network have access to it.

It is recommended to create the new storage on the same device where TNI is installed and the SQL database is located. This will speed up the process of operations and interaction with the storage files (scanning, importing, creating backups, etc.).

If a multi-user storage has already been created, the Create a new storage from existing backup option will automatically restore the storage to its previous form.

Select the Multi-user storage option.

Connect the storage to the PostgreSQL database.
To do this, specify the IP address and port of the PostgreSQL database server.

When connecting for the first time, enter the name of a user who has database administrator rights (by default, this user will be postgres).

Perform a test connection check.

If the connection fails, go to the Postgre administration panel, and in the Server Properties check the port number and other network settings.

You can check for conflicts regarding port usage by other services using TCPView.

Create a new TNI administrator user.

When creating the first multi-user storage in the database the user “Built-in TNI Administrator” is created, which has TNI administrative rights. You will then be able to use this account to log in and administer any storage created in this database, as well as to create new storage with no need for a database administrator account.

When you create a new multi-user storage, by default only administrators will have access to it. You need to edit rights and privileges in the TNI Users mode for users to get access to the storage.