Postgres

Postgres connection is a native type where queries can be audited and the output redacted. It forwards a passwordless TCP connection locally.

Connection Configuration

Name	Type	Description
HOST	env-var	The IP or Host of the Postgres server
PORT	env-var	The port of the Postgres server
USER	env-var	The user to connect in the Postgres server
PASS	env-var	The password to connect in the Postgres server

INFO

This type of connection accepts only MD5 or scram-sha-256 authentication methods.

Postgres Server

hoop connect my-postgres --port 5432

Use a compatible postgres client to connect in the instance

psql -h 127.0.0.1 mydb