This topic describes the basic information and network configurations that you can view on the Instance Details page of a Hologres instance and how to change the specifications of the instance on this page. This topic also describes available connection methods.

Basic information

The Instance Details page shows the basic information of a Hologres instance. The basic information includes the name, ID, region, version, billing method, specifications, and creation time.

You can click Upgrade or Downgrade to change the specifications of the instance. Instance details

Network configurations

You can access a Hologres instance over the Internet, the classic network, a virtual private cloud (VPC), or a specified VPC that is associated with the Hologres instance. Select a network type and a connection tool based on your business requirements.
Network type Endpoint format Description Scenario Operation
Public Network <instancename>-cn-<region>.hologres.aliyuncs.com:80 The Internet. Access over the Internet consumes traffic. Hologres does not charge you for the consumed Internet traffic. Hologres supports a bandwidth of up to 200 Mbit/s. Select this network type if you want to access a Hologres instance over a network with no limits on network connections. Scenarios:
  • You want to access a Hologres instance from a non-Alibaba Cloud device over the Internet.
  • You want to access a Hologres instance across regions or network types.
You can enable or disable this network type. By default, this network type is disabled.
Note To meet the regulatory security requirements, Hologres does not provide public endpoints for instances used by CloudTmall.
Classic <instancename>-cn-<region>-internal.hologres.aliyuncs.com:80 The classic network of Alibaba Cloud. The involved IP addresses and network resources of the classic network are planned and managed by Alibaba Cloud. Select this network type if you want to access a Hologres instance over the classic network. For example, if your application is deployed on an Elastic Compute Service (ECS) instance in the classic network, you can access a Hologres instance by using its classic network endpoint. This network type is enabled by default and cannot be disabled.
VPC <instancename>-cn-<region>-vpc.hologres.aliyuncs.com:80 A private network of Alibaba Cloud that is logically isolated from other networks. You can connect to a VPC by using an Express Connect circuit. VPCs provide improved security and flexibility than the classic network. Select this network type in the following scenarios:
  • Your application is deployed on an ECS instance in a VPC. In this case, you can access a Hologres instance by using its VPC endpoint if the ECS instance and Hologres instance reside in the same region.
  • Your application is deployed in a data center. In this case, you can connect to the VPC of a Hologres instance by using an Express Connect circuit and access the Hologres instance by using its VPC endpoint.
You can enable or disable this network type.
Note We recommend that you do not disable this network type. Otherwise, you cannot use HoloWeb.
Select VPC <instancename>-cn-<region>-vpc-st.hologres.aliyuncs.com:80 A private network of Alibaba Cloud that is logically isolated from other networks and associated with a Hologres instance.
Notice This network type is available only in the China (Shanghai), China (Beijing), and China (Shenzhen) regions.
If you select this network type, you can access a Hologres instance only over the VPC that is associated with the Hologres instance. By default, no VPC is associated with a Hologres instance.

To associate a VPC with a Hologres instance, click Associate VPC in the Actions column in the Network Information section on the Instance Details page of the Hologres instance. In the Associate VPC dialog box, set the VPC and vSwitch parameters.

Note If you use an exclusive resource group for DataWorks DataService Studio, do not associate a VPC with a Hologres instance. Otherwise, the exclusive resource group cannot be used.

Connection methods

You can click Connection Methods to view the description of common developer tools that you can use to connect to a Hologres instance. You can select a connection method and a developer tool based on your business requirements. The following two connection methods are supported:
  • Connect over JDBC
    To connect to a Hologres instance over Java Database Connectivity (JDBC) by using an extract, transform, load (ETL) tool or business intelligence (BI) tool, use the following JDBC URL:
    jdbc:postgresql://<AccessID>:<AccessKey>@<Endpoint>:<Port>/<database>?tcpKeepAlive=true

    For more information about how to use JDBC, see Use JDBC to connect to Hologres.

  • Connect from the PostgreSQL client
    Hologres is compatible with PostgreSQL. You can connect to a Hologres instance from the PostgreSQL client. To connect to a Hologres instance from the PostgreSQL client, use the following statement:
    PGUSER=<AccessId> PGPASSWORD=<AccessKey> psql -p <Port> -h <Endpoint> -d <Database>

    For more information about how to use the PostgreSQL client, see PSQL quick start.

The following table describes the parameters in the preceding JDBC URL or statement.
Parameter Description
<Access ID> The AccessKey ID of the current Alibaba Cloud account.

You can obtain the AccessKey ID on the Security Management page.

<Access Key> The AccessKey secret of the current Alibaba Cloud account.

You can obtain the AccessKey secret on the Security Management page.

<Port> The port number of the Hologres instance.

You can view the port number of the Hologres instance on the Instance Details page in the Hologres console.

<Endpoint> The endpoint of the Hologres instance.

You can obtain the endpoint in the Network Information section of the Instance Details page in the Hologres console.

<Database> The name of the database to which you want to connect.

If you do not have a database, use the postgres database that is allocated by the system.