PostgreSQL connection
To access your data in PostgreSQL, create a connection asset for it.
PostgreSQL is an open source and customizable object-relational database.
Supported versions
- PostgreSQL 15.0 and later
- PostgreSQL 14.0 and later
- PostgreSQL 13.0 and later
- PostgreSQL 12.0 and later
- PostgreSQL 11.0 and later
- PostgreSQL 10.1 and later
- PostgreSQL 9.6 and later
Create a connection to PostgreSQL
To create the connection asset, you need the following connection details:
- Database name
- Hostname or IP address
- Port number
- Username and password
- SSL certificate (if required by the database server)
For Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.
Choose the method for creating a connection based on where you are in the platform
- In a project
- Click Assets > New asset > Connect to a data source. See Adding a connection to a project.
- In a deployment space
- Click Add to space > Connection. See Adding connections to a deployment space.
- In the Platform assets catalog
- Click New connection. See Adding platform connections.
Next step: Add data assets from the connection
Where you can use this connection
You can use PostgreSQL connections in the following workspaces and tools:
Projects
- AutoAI (Watson Machine Learning)
- Decision Optimization (Watson Studio and Watson Machine Learning)
- Data Refinery (Watson Studio)
- Notebooks (Watson Studio). Click Read data on the Code snippets pane to get the connection credentials and load the data into a data structure. For more information, see Load data from data source connections.
- SPSS Modeler (SPSS Modeler service)
- Synthetic Data Generator (Synthetic Data Generator service)
- Watson Machine Learning Accelerator (Watson Machine Learning Accelerator service)
Catalogs
- Platform assets catalog
Federal Information Processing Standards (FIPS) compliance
- 4.8.0 and 4.8.1: This connection is compliant with FIPS if you installed Cloud Pak for Data on or prior to January, 22, 2024. However, the connection is not compliant if it requires SSL.
- 4.8.2 and later: This connection is not compliant with FIPS, but it is FIPS-tolerant.
For PostgreSQL connections in the Watson Machine Learning Accelerator service, see Known issues on FIPS-enabled clusters.
PostgreSQL setup
Running SQL statements
To ensure that your SQL statements run correctly, refer to the SQL Syntax in the PostgreSQL documentation.
Learn more
Parent topic: Supported connections