sails-postgresql-redacted v1.0.2-9

Sails PostgreSQL Redacted

This tracks Sails PostgreSQL, with the following changes:

• leaking of database passwords into logs is fixed (https://github.com/balderdashy/sails/issues/4595, https://github.com/balderdashy/sails/issues/4606)
• connecting to databases via unix socket is fixed (https://github.com/balderdashy/sails/issues/6888)
• connecting to databases with a pre-initialised pool object

Versions track upstream, with an extra -{increment}.

Usage with a pre-defined PG.pool

module.exports.datastores = {
  default: {
    adapter: 'sails-postgresql-redacted',
    pool: yourPoolHere,
  },
};

Usage with Unix Sockets

General

const { POSTGRES_HOST, POSTGRES_USER, POSTGRES_PASSWORD, POSTGRES_DATABASE } = process.env;
module.exports.datastores = {
  default: {
    adapter: 'sails-postgresql-redacted',
    host:     POSTGRES_HOST,
    user:     POSTGRES_USER,
    password: POSTGRES_PASSWORD,
    database: POSTGRES_DATABASE,
  },
};

Google Cloud SQL

const { GCP_PROJECT, CLOUDSQL_REGION, CLOUDSQL_INSTANCE_NAME } = process.env;
const { POSTGRES_USER, POSTGRES_PASSWORD, POSTGRES_DATABASE }  = process.env;
module.exports.datastores = {
  default: {
    adapter: 'sails-postgresql-redacted',
    host:     `/cloudsql/${GCP_PROJECT}:${CLOUDSQL_REGION}:${CLOUDSQL_INSTANCE_NAME}`,
    user:     POSTGRES_USER,
    password: POSTGRES_PASSWORD,
    database: POSTGRES_DATABASE,
  },
};