Skip Navigation

External database overview

This is a simple overview of possible steps for setting up an external database to connect to the
virtual appliance. This is not a list of requirements because configuring an external database depends on your environment. This list is simply provided as guidance and could help if you have issues connecting the database to the virtual appliance.
  1. Install PostgreSQL and PostgreSQL server.
  2. Initialize the PostgreSQL database.
  3. Start and enable autostart postgres service to start the database when the server starts.
  4. Force postgres to listen on all ports in postgresql.conf.
  5. Allow postgres port through firewall.
  6. Enable the pgcrypto extention.
  7. Create a postgres user.
    • If the database is dedicated to
      , using the default postgres user is an option.
    • If the database is shared, then you should create a new postgres user for the
      database. A shared database is not recommended for
  8. Authorize remote postgres authentication in pg_hba.conf file.
  9. Generate SSL certificates for postgres server connection.
  10. Configure SSL in postgresql.conf file.
When you connect the external database to
, consider the following:
  • Use the fully qualified domain name (FQDN) of the external database. Using the external database IP address is also an option.
  • The default port for PostgreSQL is 5432.
  • TLS/SSL requires uploading the external database certificate to
    . During initial configuration, enable
    Verify Peer Mode
    , upload the certificate, then disable
    Verify Peer Mode
  • Verify Peer Mode
    requires configuring certificates on the host and client.