Creating a PostgreSQL connection
To create a PostgreSQL connection:
-
Go to the connections page.
-
Click Create connection.
-
Select the PostgreSQL connector.
Important
When connecting to an external data source (which is not a Yandex.Cloud resource), grant access to the source for the following ranges of DataLens IP addresses:
77.88.39.88/29
93.158.158.96/29
93.158.156.80/29
77.88.39.224/28
37.9.126.112/28
37.9.65.32/28
-
Specify the connection parameters:
- Connection name. Specify a name for the connection. You can set any name.
- Hostname or IP. Specify the path to the PostgreSQL host.
- Port. Specify the PostgreSQL connection port.
- Database name. Specify the name of the database to connect to.
- Username. Specify the username for the PostgreSQL connection.
- Password. Enter the password for the specified user.
-
Click Connect. The connection appears in the list.
You can check the host connection before creating it. To do this, click Check connection.