Repository Database in PostgreSQL - DSS 6 | Data Source Solutions Documentation
Documentation: Repository Database in PostgreSQL - DSS 6 | Data Source Solutions Documentation
Repository Database in PostgreSQL
Data Source Solutions DSS allows you to create a repository database in PostgreSQL. Repository Database section in Capabilities (6.1.0, 6.1.5) lists the supported PostgreSQL versions that can be used as a repository database.
Grants for Repository Database
The following grant is required for the repository database in PostgreSQL:
- The repository User should have permission to create and drop DSS repository tables.
Repository Database Connection
This section describes the details required for connecting to the repository database in PostgreSQL:
| Field | Description | Equivalent Location Property |
|---|---|---|
| HOST | Hostname or IP-address of the server on which the PostgreSQL database is running. Example: mypostgresnode |
Database_Host |
| PORT | Port number on which the PostgreSQL database server is expecting connections. Example: 5432 |
Database_Port |
| DATABASE | Name of the PostgreSQL database. Example: mytestdb |
Database_Name |
| USER | Username for connecting DSS to the PostgreSQL database. Example: dbuser |
Database_User |
| PASSWORD | Password for the USER. | Database_Password |
Advanced Settings
| Field | Description | Equivalent Location Property |
|---|---|---|
| PGLIB | Directory path of the library (lib) directory in the PostgreSQL installation. This field can be left empty to use the system default path. Example: /postgres/935/lib |
PostgreSQL_Pglib |