Chapter 8. Getting Started With Veil2 (STEP 1)

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

8.1. Installing Veil2

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.

8.1.1. Installing To Your Server Using The pgxn Client

If you have the pgxn client available on your database server you can simply do this:

# pgxn install veil2
	

If not, you can download Veil2 from PGXN or github, and then build and install it locally as described here.

8.1.2. Per-Database Install

Installing the Veil2 extension in a given database is done with the following command, eg from psql:

dbname# create extension veil2 cascade;
	

Note that cascade is used to ensure that Veil2's extension dependencies are also installed.

8.2. Next Steps

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.