On this page:
Target audience:
- CAST AI Administrators
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 | - |
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 |
|
|---|---|
| CSS 3 |
|
| CSS 2 |
|
