Skip to main content

Setting Up User Portal Data Storage

Configure User Portal data storage. User Portal instances may be set up against a local cache, an internal PostgreSQL database, or an external PostgreSQL database.

If you are setting up against PostgreSQL, you must set up an internal or an external PostgreSQL server: you will need to install the PostgreSQL server package (along with any required dependencies), initialize the PostgreSQL cluster, and start the PostgreSQL service. After this, you can use the setup-database utility to automatically create a database on the PostgreSQL, and to configure User Portal to use that database:

Option 1: Internal PostgreSQL database​

Install PostgreSQL on the machine. Then configure User Portal to use the local database with the following command:

# /opt/sshmgr-user-portal/bin/setup-database --local

The previous command creates a local database named sshmgrup, with a database user sshmgrup for User Portal use.

Option 2: External PostgreSQL database​

Set up User Portal against a remote PostgreSQL database with:

# /opt/sshmgr-user-portal/bin/setup-database

You will be prompted for the following database-connection details:

  • The database type. Select remote to configure a remote detabase.

    The FQDN or the IP address of the PostgreSQL database machine. The address must be resolvable by the User Portal machine.

  • The port used by the PostgreSQL database. Defaults to 5432.

  • The name of the database user who has full rights to the User Portal database.

  • The password of the database user.

  • The name of the database intended for User Portal use.

Option 3: Local cache​

To set up User Portal to store data in a local cache:

# /opt/sshmgr-user-portal/bin/setup-database --cache