Overview
- Introduction
- Authentication
- Examples
Endpoints
- Identities
- Token Auth
- Universal Auth
- GCP Auth
- AWS Auth
- Azure Auth
- Kubernetes Auth
- OIDC Auth
- JWT Auth
- Groups
- Organizations
- Projects
- Project Users
- Project Groups
- Project Identities
- Project Roles
- Project Templates
- Environments
- Folders
- Secret Tags
- Secrets
- Dynamic Secrets
- Secret Imports
- Secret Rotations
- Identity Specific Privilege
- App Connections
- GETList
- GETOptions
- Auth0
- AWS
- Azure App Configuration
- Azure Client Secret
- Azure Key Vault
- Camunda
- Databricks
- GCP
- GitHub
- Hashicorp Vault
- Humanitec
- LDAP
- Microsoft SQL Server
- PostgreSQL
- TeamCity
- Terraform Cloud
- Vercel
- Windmill
- GET
- Secret Syncs
- Integrations
- Service Tokens
- Audit Logs
Infisical PKI
- Certificate Authorities
- Certificates
- Certificate Templates
- Certificate Collections
- PKI Alerting
Infisical SSH
- Hosts
- Host Groups
- Certificates
- Certificate Authorities
- Certificate Templates
Infisical KMS
- Keys
- Encryption
- Signing
Create
Create a PostgreSQL Connection for the current organization.
curl --request POST \
--url https://us.infisical.com/api/v1/app-connections/postgres \
--header 'Content-Type: application/json' \
--data '{
"method": "username-and-password",
"credentials": {
"host": "<string>",
"port": 123,
"database": "<string>",
"username": "<string>",
"password": "<string>",
"sslEnabled": true,
"sslRejectUnauthorized": true,
"sslCertificate": "<string>"
},
"name": "<string>",
"description": "<string>",
"isPlatformManagedCredentials": false
}'
{
"appConnection": {
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"name": "<string>",
"description": "<string>",
"version": 1,
"orgId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"createdAt": "2023-11-07T05:31:56Z",
"updatedAt": "2023-11-07T05:31:56Z",
"isPlatformManagedCredentials": false,
"credentialsHash": "<string>",
"app": "postgres",
"method": "username-and-password",
"credentials": {
"host": "<string>",
"database": "<string>",
"port": 123,
"username": "<string>",
"sslEnabled": true,
"sslRejectUnauthorized": true,
"sslCertificate": "<string>"
}
}
}
Check out the configuration docs for PostgreSQL Connections to learn how to obtain the required credentials.
Body
The method used to authenticate with PostgreSQL.
username-and-password
The credentials used to connect with PostgreSQL.
The hostname of the database server.
1
The port number of the database.
The name of the database to connect to.
1
The username to connect to the database with.
1
The password to connect to the database with.
1
Whether or not to use SSL when connecting to the database.
Whether or not to reject unauthorized SSL certificates.
The SSL certificate to use for connection.
The name of the PostgreSQL Connection to create. Must be slug-friendly.
1 - 32
An optional description for the PostgreSQL Connection.
256
Whether or not the PostgreSQL Connection credentials should be managed by Infisical. Once enabled this cannot be reversed.
Response
postgres
username-and-password
The hostname of the database server.
1
The name of the database to connect to.
1
The port number of the database.
The username to connect to the database with.
1
Whether or not to use SSL when connecting to the database.
Whether or not to reject unauthorized SSL certificates.
The SSL certificate to use for connection.
Was this page helpful?
curl --request POST \
--url https://us.infisical.com/api/v1/app-connections/postgres \
--header 'Content-Type: application/json' \
--data '{
"method": "username-and-password",
"credentials": {
"host": "<string>",
"port": 123,
"database": "<string>",
"username": "<string>",
"password": "<string>",
"sslEnabled": true,
"sslRejectUnauthorized": true,
"sslCertificate": "<string>"
},
"name": "<string>",
"description": "<string>",
"isPlatformManagedCredentials": false
}'
{
"appConnection": {
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"name": "<string>",
"description": "<string>",
"version": 1,
"orgId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"createdAt": "2023-11-07T05:31:56Z",
"updatedAt": "2023-11-07T05:31:56Z",
"isPlatformManagedCredentials": false,
"credentialsHash": "<string>",
"app": "postgres",
"method": "username-and-password",
"credentials": {
"host": "<string>",
"database": "<string>",
"port": 123,
"username": "<string>",
"sslEnabled": true,
"sslRejectUnauthorized": true,
"sslCertificate": "<string>"
}
}
}