Skip to main content

Connecting to PostgreSQL

How to open a psql session against the Informer database, for inspection or maintenance.

Back up first

Connecting to PostgreSQL is an opportunity to make mistakes that lose data. Back up PostgreSQL before continuing: Backups and restores (Windows) or Backups and restores (Linux w/ Docker).

Windows​

The connection details are in the db section of Informer's config.json (user, password, database, host, port). If any option is missing, omit it from the command.

"db": {
  "database": "informer5",
  "host": "localhost",
  "user": "postgres",
  "password": "informer5",
  "port": 5432
}

In a PowerShell window (it may need to run as Administrator), connect with the values from config.json:

psql -U <user> -d <database> -h <host> -p <port>

When prompted, enter the password from config.json.

Linux (Docker)​

The connection details are in the environment section under each Informer container in docker-compose.yml (user and database). If any option is missing, omit it from the command.

docker-compose exec postgres psql -U <user> -d <database>