PostgreSQL
By connecting PostgreSQL database to Hops, all team members can use the database in their workflows.
Connection Method
Hops uses fixed IP addresses when accessing your database.
If you manage a list of IPs that can access your database through a firewall, please add the following IPs to your allowlist:
34.47.79.49, 34.47.86.94
Log into Hops and click the data source button on the left.
Click the add new data source button at the bottom left.
Select PostgreSQL from the data source types.
Enter Connection Information
Enter the required information to connect to the PostgreSQL data source.
Please refer to the table below for detailed descriptions of the required information.
| Property | Description |
|---|---|
| Data Source Alias | Enter an easily recognizable name for other team members. This is the display name in Hops, different from the database name required for connection. |
| Host | The database host information. Enter an IP address or domain name. Make sure not to include special characters like @ or :. |
| Port | Enter the database port number. If not specified, port 5432 will be used by default. |
| Database User | Enter the username for database connection. If you want to add a new account, please refer to: PostgreSQL Create User documentation |
| Database Password | Enter the password for database connection. Database connection information is securely encrypted. |
| Database Name | Enter the name of the database you want to connect to. You can check database names through: PostgreSQL current_database() function |
| SSH Tunneling Host | If you're using SSH tunneling, enter the bastion host address. |
| SSH Public Key | The public key to be added to the bastion's authorized_keys file. |
Having trouble because you don't have the required information to connect to the database?
Contact us by email (contact@hopsoffice.com) and
we'll help you through remote support.
Connection Test
Click the connection test button to verify the connection.
When the connection succeeds, the connection test button changes to a connection success button.
Once you've entered all connection information and the connection test succeeds, you can click the add button to add the data source.
Having trouble with failed database connections?
Contact us by email (contact@hopsoffice.com) and
we'll help you through remote support.
Using in Workflows
After adding the PostgreSQL data source, all team members can access the added data source in workflows.
