Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...


Panel

Table of Contents

Requirements

...

  • Install a PostgreSQL database server.

  • Once the installation is complete, initialize the PostgreSQL database.

  • Start the PostgreSQL Server:

For eaxmpleexample, from the Service Management Console management:

...

Finally change the pg_hba.conf, to allow database connection with password.

For example, for a system where the database server is on the same host as the UDMG server, by changing this line from:

Panel

host all all 127.0.0.1/32 ident

to:

Panel

host all all 127.0.0.1/32 md532 scram-sha-256

For a system where the database server is on the same subnet as the UDMG server, change it to:

Panel

host all all samenet scram-sha-256

The exact configuration depends on the OS and database version, on the preferred security settings, and on the system architecture.

...

Panel

postgres=# SHOW hba_file;

The current password encryption method can be returned by PostgreSQL Console (psql):

Panel

postgres=# SHOW password_encryption;

NGINX Server

Note: The following steps require Administrator privileges, be sure that you have the correct access before to continue.

...

Name

Location

PostgreSQL Client Authentication

PostgreSQL Password Authentication

Guide on setting up Nginx as a service on Windowshttps://github.com/sheggi/win-service-nginx

...