Breadcrumbs

Configure the PostgreSQL database

In this article, you'll learn how to set up and configure the PostgreSQL database to use NDD Print MF Epson.

Before you start

  • This configuration is applicable only to scenarios in which the installation or update of NDD Print MF Epson was carried out using the option "I have a PostgreSQL database and I want to use it".

  • This configuration must be carried out before adding new printers to NDD Print MF Epson.

  • It is recommended that you always use a dedicated database for NDD Print MF Epson.

  • 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

The Owner user must have read and write permission on the database.

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

image-20240712-132735.png

  1. Click on Save

Step 2: Configuring database access

  1. Open the NDD Print MF Epson interface

  2. In the menu, click on Tools > Settings

image-20240711-161444.png

  1. Select PostgreSQL

  2. Fill in the database information

If you use a user with permission to create, NDD Print MF Epson will create the tables in the selected database. If you don't have permission to create, use the SQL script.

  1. Click Apply > OK

How to migrate data from a Postgresql database.

Step 3: Create the database tables

  1. Go to the NDD Print MF Epson installation folder

  2. Open the CreateDatabasePostgres.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 CreateDatabasePostgres.sql file and click execute image-20240712-140519.png

  6. When finished, configure access to the database

Common errors

Errors

Solution

  • Add printer error

  • Administration interface empty

  • NDD Print Client does not start on the printer

  • Authentication not working

Check that the postgreSQL service is running.