NAV Navbar
Switch version:

Requirements

  1. If the DB user you are going to configure the plugin with already has superuser or rds_superuser (Amazon RDS) privileges, the citext extension will automatically be created through a pre-packaged migration upon configuring the plugin.

  2. If the DB user you are going to configure the plugin with is just a user of the analytics database, but not a superuser, then the citext extension will have to be created manually. To do this, connect to the PostgreSQL server as a user with ‘superuser’ privileges and run CREATE EXTENSION IF NOT EXISTS citext; on the empty database to be used for the analytics plugin.

On Amazon RDS:

CREATE ROLE "gocd_analytics_user" PASSWORD 'gocd_analytics_password' NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN;
CREATE DATABASE "gocd_analytics";
GRANT ALL PRIVILEGES ON DATABASE "gocd_analytics" TO "gocd_analytics_user";
GRANT rds_superuser TO "gocd_analytics_user";

On a normal Postgres server instance:

CREATE ROLE "gocd_analytics_user" PASSWORD 'gocd_analytics_password' NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN;
CREATE DATABASE "gocd_analytics";
GRANT ALL PRIVILEGES ON DATABASE "gocd_analytics" TO "gocd_analytics_user";
ALTER ROLE "gocd_analytics_user" SUPERUSER;

Installation

The GO_SERVER_DIR is usually /var/lib/go-server on Linux and C:\Program Files(x86)\Go Server on Windows. You can find the location of the GoCD Server installation here.