Hashing on PostgreSQL

If you're using PostgreSQL as the target database to host your data warehouse. You might encounter this config issue on a clean, of the shelve Postgres install.

org.postgresql.util.PSQLException: ERROR: function digest(text, unknown) does not exist

The digest function is the function that executes the hashing of business keys in VaultSpeed code. As you can see in the example below. This function must be configured on your Postgres environment.

Luckily, this is easy to configure; the only thing you need to do is run the following command on your Postgres:

CREATE EXTENSION pgcrypto;

The pgcrypto module provides cryptographic functions for PostgreSQL. It supports MD5 and SHA1 algorithms, commonly used in DV2 hashes.

This module is considered “trusted”, that is, it can be installed by non-superusers who have CREATE privilege on the current database.

Happy hashing 🎉