index.ts

import * as pulumi from "@pulumi/pulumi";
import * as docker from "@pulumi/docker";
import * as pg from '@pulumi/postgresql';

const cfg = new pulumi.Config();
const network = new docker.Network("net");

const pgImg = new docker.RemoteImage("postgresql-image", {
  name: "postgres:11",
  keepLocally: true
});

const pgVol = new docker.Volume('pgdata');

const pgContainer = new docker.Container("postgres", {
  image: pgImg.name,
  networksAdvanced: [{ name: network.name }],
  restart: "on-failure",
  volumes: [{ volumeName: pgVol.name, containerPath: '/var/lib/postgresql/data' }],
  envs: [
    `POSTGRES_USER=${cfg.require('pguser')}`,
    cfg.requireSecret('pgpass').apply(p => `POSTGRES_PASSWORD=${p}`),
  ],
  ports: [{ internal: 5432, external: 5432 }]
});

let pgProvider = new pg.Provider("pg", {
	host: pgContainer.ipAddress,
	username: cfg.require('pguser'),
	password: cfg.requireSecret('pgpass'),
});

const db = new pg.Database('MyCoolDatabase', {}, {provider: pgProvider});