PostgreSQL

  • Make sure that CopyStorm is being utilized by a PostgreSQL database.  If this is the first time being utilized, follow the best practice instructions for a PostgreSQL database utilizing CopyStorm
  • CS:Govern for PostgreSQL requires that the pgcrypto package be installed.  On most installations of CopyStorm, when a PostgreSQL database schema is created, this library will have been automatically added.  However on older CopyStorm installations it is possible that pgcrypto was not included.  If that is the case then the following command will add this required package:  CREATE EXTENSION IF NOT EXISTS pgcrypto
  • Protect Data By Utilizing CS:Govern. This will add the tables, functions and scripts needed for CS:Govern to be utilized.
  • Issue this command as the Database Administrator:  REVOKE SELECT ON GuardianKey FROM public;