Pivotal Knowledge Base

Follow

Encrypting Data with the GPDB pgcrypto Extension Package

Environment

Pivotal Greenplum Database (GPDB) all versions

Introduction

The attached document attached contains an example of how to encrypt and decrypt data in a Greenplum Database (GPDB) database with the GPDB pgcrypto extension package and the gpg encryption utility.

Description

The GPDB extension package pgcrypto provides built-in cryptographic functions (for data at rest) to encrypt and decrypt sensitive information, such as SSNs, credit card numbers, etc. pgcrypto provides PGP encryption functions using symmetric and asymmetric encryption. 

The gpg utility is used to create PGP public and private keys that are used to encrypt and decrypt the data stored in the GPDB database.

This document does not cover all encryption features available the with the pgcrypto extension package. Please refer to the GPDB documentation guides for information on how to use and implement specific features.

Comments

Powered by Zendesk