logger.ts

import Logger from 'bunyan';
import PrettyStream from 'bunyan-pretty-colors';

const logStream = new PrettyStream();
logStream.pipe(process.stdout);

const log = Logger.createLogger({
  name: 'message-consumer',
  streams: [{
    level: 'info',
    type: 'raw',
    stream: logStream
  }]
});

export const getLogger = (): Logger => log;

postgresClient.ts

import knex, { Knex } from 'knex';
import { getLogger } from '../services/logger';

let client: Knex;

export const getClient = (): Knex => {
  if (!client) {
    client = knex({
      client: 'pg',
      version: '7.2',
      connection: {
        host: process.env.POSTGRES_HOST,
        user: process.env.POSTGRES_USER,
        password: process.env.POSTGRES_PASSWORD,
        database: process.env.POSTGRES_DB
      }
    });
  }

  return client;
};