Versions Compared

Key

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


Panel

Table of Contents

...

  • Install a PostgreSQL database server.

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

  • Start the PostgreSQL Server:




Panel

# systemctl start postgresql




  • Create a user for UDMG Waarp GatewayServer

Login as PostgreSQL administrative user, start the PostgreSQL Console (psql) and create the database user for UDMG:

...

  • 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 md5

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

...

For example, from the Service Management Console management:

  • Create a user for UDMG Waarp GatewayServer

Login as PostgreSQL user, start the PostgreSQL Console (psql) and create the database user:

...

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 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.

The location of the pg_hba.conf can be returned by PostgreSQL Console (psql):

Panel

postgres=# SHOW hba_file;

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

...