Skip to main content
Create a PostgreSQL TimescaleDB cluster
Last update:

Create a PostgreSQL TimescaleDB cluster

Create a cluster

  1. In the control panel, go to Cloud PlatformDatabases.

  2. Click Create Cluster.

  3. Enter a name for the cluster.

  4. Select a region.

  5. Select a pool.

  6. Select version PostgreSQL TimescaleDB. Once created, the version will not be able to be changed.

  7. Select node configuration:

    • fixed — configurations with different ratio of virtual processor cores, RAM and local disk;
    • arbitrary — free choice of resource ratio.
  8. For fixed configuration, select configuration line:

    • Standard Line;
    • HighFreq Line.
  9. Optional: check the Add replicas checkbox and specify the number of replicas. Replicas increase the fault tolerance of the cluster.

  10. Select the type of subnet to which the cluster will be connected:

    • private subnet — a subnet with no access from the Internet. You can connect a static public IP address;

    • public subnet — all public subnet addresses are accessible from the Internet.

  11. Select or create a subnet.

    Addresses are assigned to each node in the cluster. Make sure that the number of addresses in the subnet is not less than the number of nodes in the cluster. If you plan to increase the number of replicas after the cluster is created, select a subnet that has a stock of free addresses. Once the cluster is created, the subnet cannot be changed.

    You can limit the list of addresses from which access to the database cluster will be allowed.

  12. Optional: in a private subnet you can connect a public IP address to a cluster node:

  13. Select connection-pooler mode:

    • transaction — the connection is assigned to the client for the duration of the transaction;
    • session — connection is assigned while the client is connected;
    • statement — transactions with multiple statements are prohibited.
  14. Select pool-size.

  15. Optional: change DBMS settings, to do so click Change. We recommend that you change the settings only when necessary — incorrect values can degrade cluster performance.

  16. Click Create Database Cluster. The cluster will be ready for operation when it moves to the ACTIVE status.

Create a database

  1. Create user — The database must have an owner user.
  2. In Control Panel, go to Cloud PlatformDatabases.
  3. Open the cluster page → Databases tab.
  4. Click Create Database.
  5. Enter the name of the database.
  6. Select the user who owns the database.
  7. Enter the character set locale (LC_CTYPE) — responsible for character classification and case differences. Once the database is created, you cannot change the locale. For more information about locales, see PostgreSQL documentation.
  8. Enter sort locale (LC_COLLATE) — determines string and character comparison settings and affects sorting. Once the database is created, you cannot change the locale.
  9. Press Create.