Location Connection for PostgreSQL - DSS 6 | Data Source Solutions Documentation
Documentation: Location Connection for PostgreSQL - DSS 6 | Data Source Solutions Documentation
Location Connection for PostgreSQL
This section describes the connection details required for creating a PostgreSQL location in Data Source Solutions DSS. For information about the pre-requisites, access privileges, and other configuration requirements for creating Oracle location, see PostgreSQL Requirements.
If the managed secrets feature is enabled, option USE TOKEN INSTEAD is displayed in the fields designated for entering secrets.
| 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: dssuser |
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 |