Prev  Up  Next
Chapter 7. Setting Up A Veil2 Virtual Private Database - Overview  Home  Chapter 9. Identify and Define Your Scope Types (STEP 2)

This section aims to help you get Veil2 installed on your database server, and into your database.

Since version 0.9.1, Veil2 can and should be installed as a PostgreSQL extension. It is available from PGXN the PostgreSQL Extension Network.

Alternatively it can be downloaded from github and built locally. For more on this see the developers section.

The following chapters describe in detail the next steps to take in securing your database with Veil2. These chapters assume that you will be looking at the Veil2 demos for examples. You can find the demo files on your database server by executing the following query: 

dbname# select * from veil2.sql_files;

This lists a number of files that you can take a look at. There are 3 files that you should take copies of:

  • the Veil2 demo creation script;

    This is referenced from most of the following chapters, and provides useful, though often incomplete, examples of what needs to be done at each step.

  • the Veil2 minimal-demo creation script;

    This provides a complete example of the simplest possible Veil2 installation. It avoids using the more sophisticated features of Veil2 but by virtue of being a complete implementation may provide more helpful code examples.

  • the Veil2 implementation template.

    This is a template script for you to use as the basis of your Veil2 implementation. It identifies all of the steps needed and provides commented-out examples and templates for you to use.

If you cannot access these files on your database server, you can most easily access them from github or by downloading from pgxn.

Prev  Up  Next
Chapter 7. Setting Up A Veil2 Virtual Private Database - Overview  Home  Chapter 9. Identify and Define Your Scope Types (STEP 2)