FQDNs of PostgreSQL hosts

To connect to a host, you need its fully qualified domain name (FQDN). You can get it using one of the following methods:

• Request a list of cluster hosts.

• In the management console, copy the cluster connection command (it contains the host’s FQDN). To get the command, go to the cluster page and click Connect.

• Look up the FQDN in the management console:

  1. Navigate to the cluster page.
  2. Navigate to Hosts.
  3. Copy the Host FQDN column value.

Cluster hosts also use special FQDNs.

Special FQDNsSpecial FQDNs

Alongside regular FQDNs, Managed Service for PostgreSQL offers special FQDNs that can be also used for cluster connections.

In multiple-host clusters, special FQDNs may for some time (up to 10 minutes) point to the old host, even if it has changed its role (e.g., from a master to a replica). If using a special FQDN which points to the current master, some write requests may fail if routed to the replica. This is because it takes time to update DNS records for special FQDNs. If your write request returns an error, repeat it later.

Current masterCurrent master

An FQDN in c-<cluster_ID>.rw.mdb.yandexcloud.net format always points to the current master host in the cluster. You can get the cluster ID from the folder’s cluster list.

When connecting to this FQDN, you can perform read and write operations.

Most recent replicaMost recent replica

An FQDN in c-<cluster_ID>.ro.mdb.yandexcloud.net format points to the replica that is most up-to-date with the current master. You can get the cluster ID with the list of clusters in the folder.

Specifics:

• When connecting to this FQDN, you can only perform read operations.
• If there are no active replicas in the cluster, this FQDN will point to the current master host.
• Replicas with a manually configured replication source cannot be selected as most up-to-date replicas when using this FQDN.

Selecting an FQDN and cluster connection methodSelecting an FQDN and cluster connection method

You can connect to a cluster using its host FQDNs or special FQDNs: If the cluster consists of several hosts, keep in mind that the current master can become a replica at any moment, and vice versa.

Use one of the following methods to connect to the master host with read and write access:

• Connect using the special FQDN pointing to the current master.

  After a master failover, this FQDN may temporarily point to the previous master, now a replica, due to the time required for the DNS record to update.

  Therefore, applications using this FQDN must be designed to handle temporary master unavailability. For example, they should retry write requests after a short delay.

  Connection example

  In this example, we use the c9qash3nb1v9******** cluster ID:

  psql "host=c-c9qash3nb1v9********.rw.mdb.yandexcloud.net \
        port=6432 \
        sslmode=verify-full \
        dbname=<DB_name> \
        user=<username>"
  

• Connect by listing all cluster hosts and specifying target_session_attrs=read-write.

  Connection example

  Here, we list all the cluster’s hosts.

  The host IDs are rc1a-be***.mdb.yandexcloud.net, rc1b-5r***.mdb.yandexcloud.net, and rc1d-t4***.mdb.yandexcloud.net:

  psql "host=rc1a-be***.mdb.yandexcloud.net,rc1b-5r***.mdb.yandexcloud.net,rc1d-t4***.mdb.yandexcloud.net \
        port=6432 \
        sslmode=verify-full \
        dbname=<DB_name> \
        user=<username> \
        target_session_attrs=read-write"
  

Use one of the following methods to connect to the host with read access:

• Connect using a special FQDN pointing to the most up-to-date replica.

  Connection example

  In this example, we use the c9qash3nb1v9******** cluster ID:

  psql "host=c-c9qash3nb1v9********.ro.mdb.yandexcloud.net \
        port=6432 \
        sslmode=verify-full \
        dbname=<DB_name> \
        user=<username>"
  

• Connect by listing all cluster hosts and specifying target_session_attrs=any.

  Connection example

  Here, we list all the cluster’s hosts.

  The host IDs are rc1a-be***.mdb.yandexcloud.net, rc1b-5r***.mdb.yandexcloud.net, and rc1d-t4***.mdb.yandexcloud.net:

  psql "host=rc1a-be***.mdb.yandexcloud.net,rc1b-5r***.mdb.yandexcloud.net,rc1d-t4***.mdb.yandexcloud.net \
        port=6432 \
        sslmode=verify-full \
        dbname=<DB_name> \
        user=<username> \
        target_session_attrs=any"