Skip to content

Choose the MetaMiner Database

Decide whether the MetaMiner Database (MMDB) runs as the embedded PostgreSQL that ships with MetaMiner or on a PostgreSQL server you manage.

Before you begin

  • The MetaMiner Database is always PostgreSQL. Other database products are not supported for the MMDB.
  • The MetaMiner Server creates and upgrades every schema itself when it starts. You never run MetaMiner SQL scripts by hand.

Compare the options

Item Value
MMA database type Postgres (embedded)
PostgreSQL version 16.3, shipped in server\pgsql-win-16.3.2\
Windows service InfolytikPostgres
Port 49614
Database / owner metaminer / mmuser
Data folder server\data\mmdb\
Created Automatically on the first start of the MetaMiner Server

Choose this unless your organization requires databases on a managed PostgreSQL server. Nothing to install or provision.

Item Value
MMA database type Postgres
PostgreSQL version 16 or later recommended
You provide Host, port, database name, owner account and password
Created You create the empty database and the owner account; MetaMiner creates the schemas

Choose this when your DBA team must host, patch and back up all databases, or when you need the database on separate hardware.

  • The MetaMiner Administrator warns when the PostgreSQL major version is older than 16.
  • Setup steps: External PostgreSQL.

TODO: confirm the supported external PostgreSQL versions and required privileges

Confirm the minimum and maximum certified PostgreSQL versions for an external MMDB, and the exact privileges the owner account needs (the server creates schemas and a read-only role at startup).

Steps

  1. Open the MetaMiner Administrator.
  2. In MetaMiner Database Configuration, click Configure MMDB.
  3. Select the database type: Postgres (embedded) or Postgres.
  4. For Postgres, enter host, port, database, user name and password.
  5. Save and close the dialog.

Image of the Configure MMDB dialog with Postgres (embedded) selected and its host and port

../images/get-started/mma-configure-mmdb.png

Verify

  • The MetaMiner Database Configuration section of the MetaMiner Administrator shows a green status after the connection test.
  • For embedded: after the first server start, Windows Services lists InfolytikPostgres as running.

Troubleshooting

The MetaMiner Administrator reports an older PostgreSQL version

Installations upgraded from older releases can still run an older embedded PostgreSQL. Contact Infolytik support to plan the move to PostgreSQL 16.

Port 49614 is in use

Another program holds the port. Free the port, or select Allow to edit PG embedded host/port on Preferences > Settings... > Advanced and then change the port in Configure MMDB before the first start. See Startup and Upgrade Problems.

Next steps