Configure the PostgreSQL database

In this article, you will learn how to create and configure the PostgreSQL database to use NDD Print MF HP.

Before you start

• This configuration is only for scenarios in which the NDD Print MF HP installation or upgrade was carried out using the “I have a PostgreSQL database and want to use it” option.

• This setting must be made before adding new printers to NDD Print MF HP.

• It is recommended that you always use a unique database for NDD Print MF HP.

• Only administrator users can configure the database.

• If you already have an operational database being used by other NDD Print MF HP, the new NDD Print MF HP that will be connected to the same database must be removed and reinstalled by selecting the option “I have a PostgreSQL or SQL Server database and I want to use it”.

• We recommend that you make a backup of the database.

Step 1: Create the database

This step is only for cases where you don't have a database created.

This tutorial was created using pgAdmin 4 8.9.

1. Open the pgAdmin interface

2. Click on Object > Create > Database

3. In the General tab, fill in the name of the database and the Owner

You need a user with permission to create a database.

4. In the SQL tab you can see a summary of the database settings:

Step 2: Configuring database access

1. Open the NDD Print MF HP interface

2. In the menu, click on Tools > Settings

3. Select PostgreSQL

4. Fill in the database information

If you use a user with database creation permission, NDD Print MF HP will create the database and migrate the data. If you don't have create permission, use the SQL script.

5. Click Apply > OK

Step 3: Create the database tables

1. Go to the NDD Print MF Epson installation folder

2. Open the CreateDatabasePostgresMFHP.sql file and copy its contents

3. In pgAdmin, right-click on the created database

4. Click on Query tool

5. Paste the contents of the CreateDatabasePostgresMFHP.sql file and click execute

6. When finished, configure access to the database

{{component-feedback-article}}