CAST Storage Service - What to expect after installation

On this page:

Target audience:

  • CAST AI Administrators
Summary: this page provides information about what you should expect when you install a CAST Storage Service.

Windows service

The CAST Storage Service is installed as a Windows Service (click to enlarge):


It is configured as follows:

  • Startup Type: set to Automatic to restart the service should it stop or if Windows is rebooted.
  • Log On As: Local System

Windows processes

When the CAST Storage Service is running, several PostgreSQL related processes will be seen in Task Manager (click to enlarge):


Windows Start Menu

The installer will create the following Start menu items automatically:

CSS 4

CSS 3


CSS 2

  • pgAdmin3/pgAdmin4: launches the PostgreSQL database management console

Default database users/roles and passwords

When a CAST Storage Service is installed, two users/roles are created by default with the following passwords:

User

Default password

Purpose

operator

CastAIP

This user/role is designed to be used for all interaction with CAST AIP applications. It has full read and write access to all the schemas stored on the CAST Storage Service with the following privileges:

Click to enlarge

guest

WelcomeToAIP

This user/role is designed to be used by third party tools requiring simple read-access to the schemas stored on the CAST Storage Service with the following privileges:

Click to enlarge

Note that this user/role is no longer used by any CAST applications from CAST AIP 8.3.11. We highly recommend that if you are using this user/role, that you stop doing so and switch to the default operator user.
admin-

The admin and postgres users/roles are created by default with the privileges as listed in the images below. If you are concerned about security, you should disable logins for these users/roles.

admin

Click to enlarge

postgres (identical privileges to operator user/role)

Click to enlarge

postgres-
Since CAST AIP 8.3.12 it is not possible to change these passwords through the CAST Management Studio: you can change these passwords (recommended) using a tool such as PGAdmin.

Custom database users

If you are using CAST AIP ≥ 8.3.12, you are also free to create your own users and then use them with CAST AIP and related software - you need to have a minimum of one user with the SUPERUSER permission and then grant the "postgres" role to this user. You can create custom users using a tool such as PGAdmin. An example SQL script for a user called "my_custom_user" is shown below:

CREATE USER my_custom_user WITH
	LOGIN
	SUPERUSER
	CREATEDB
	CREATEROLE
	INHERIT
	REPLICATION
	CONNECTION LIMIT -1
	PASSWORD 'xxxxxx';

GRANT postgres TO my_custom_user;

When using CAST AIP ≥ 8.3.30, it is possible to create custom users that do NOT require the SUPERUSER permission if you prefer not to grant this. For example, this script creates a role "my_custom_role" with the password "my_password" that can login. The role has not been granted the SUPERUSER permission and instead only the minimum permissions required to operate CAST AIP are granted:

CREATE ROLE my_custom_role LOGIN PASSWORD 'my_password' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
GRANT CREATE, CONNECT, TEMPORARY on DATABASE postgres to my_custom_role;

Which third-party items are installed with the CAST Storage Service?

When you complete an installation using the CAST Storage Service installer, if they are not already installed, the following third-party items will be installed to the target workstation:

CSS 4
  • Microsoft Visual C++ 2015, 2017 and 2019 (x64 and x86)
  • pgAdmin4 4.19 (PostgreSQL database management console)
CSS 3
  • Microsoft Visual C++ 2013 Redistributable (x64 and x86)
  • Microsoft Visual C++ 2017 Redistributable (x64) - since version 3.0.1
  • pgAdmin4 (PostgreSQL database management console)
CSS 2
  • Microsoft Visual C++ 2010 Redistributable (x64)
  • pgAdmin3 (PostgreSQL database management console)