PostgreSQL system¶

The PostgreSQL system represents a PostgreSQL RDBMS available on the network. See the supported column types list for a overview of which PostgreSQL column types are supported and how they are mapped to Sesam types.

Prototype¶

{
  "_id": "sql_system_id",
  "type": "system:postgresql",
  "name": "The PostgreSQL Database",
  "username":"$ENV(username-variable)",
  "password":"$SECRET(password-variable)",
  "host":"fqdn-or-ip-address-here",
  "port": 5432,
  "database": "database-name",
  "sslmode": "prefer"
  }

Properties¶

Property	Type	Description	Default	Req
`username`	String	Username to use when connecting to the database.		Yes
`password`	String	Password to use when connecting to the database.		Yes
`host`	String	Host name or IP address to the database server. Must be DNS resolvable if non-numeric.		Yes
`port`	Integer	Database IP port.	5432
`database`	String	Name/id of database to connect to.		Yes
`sslmode`	String	The ssl mode to use. The value has to be one of “disable”, “allow”, “prefer”, or “require”. Please consult the PostgreSQL documentation for the full details of what these modes entail.	`"prefer"`

Example configuration¶

Example PostgreSQL configuration:

{
    "_id": "postgresql_db",
    "name": "PostgreSQL test database",
    "type": "system:postgresql",
    "username": "$ENV(username-variable)",
    "password": "$SECRET(password-variable)",
    "host": "test.postgresql.mydomain.com",
    "database": "test"
}

Oracle TNS system

REST system