PostgreSQL is supported as a database backend, and requires a Premium license - SQLite is the only database type available without one.


Windows


  1. Make sure your PostgreSQL server is reachable from the Streamer machine, and that you have a username/password with access to it.
  2. Start the Helium Streamer Launcher and go to the Database page.
  3. Click Create new database... (for a fresh database) or Open database... (to connect to an existing one).
  4. Select PostgreSQL from the Database type list.
  5. Fill in:
    - PostgreSQL Server - the hostname or IP address of your server.
    - Port - defaults to 5432, the standard PostgreSQL port.
    - Username and Password - credentials for that server.
    - Database name (when creating a new database), or pick your existing Helium database from the list (when connecting to one).
  6. Click Verify and save.


Linux / Raspberry Pi


Run the Configurator's interactive setup:


./Streamer.Configurator.Console prepare --interactive


Choose PostgreSQL as the database type (requires the same Premium license as on Windows). You'll be prompted for the server host, port (default 5432), database name, username, and password - the same information as above.


Notes


  • Connection is via standard username/password authentication - no special configuration is required on the PostgreSQL server itself beyond a reachable account with access to the database.
  • Unlike the MySQL setup, there's no character-set override needed - PostgreSQL's defaults work as-is.