PostgreSQL for 1C

Версии и конфигурации

Доступные версии PostgreSQL для 1С, фиксированные и произвольные конфигурации нод кластера

Local disks

Features of local disks

Create a cluster

How to create a PostgreSQL cluster for 1C and connect the database to the 1C server

Настройки PostgreSQL для 1С

Как изменить настройки PostgreSQL для 1С

PostgreSQL Extensions for 1C

List of PostgreSQL extensions that we connect to work with 1C:Enterprise

Connection Pooler

The role of the connection pooler and the connection pooler that PostgreSQL uses for 1C

User management

How to create a user, change his password, configure database access and work with privileges

Connect to the cluster

How to connect to PostgreSQL cluster for 1C with or without SSL certificate in console and from different programming languages

Monitoring

How to track the status of nodes, databases and cluster and how to export metrics in Prometheus format

Scale the cluster

How to change the configuration of a node cluster

Backup

Backup schedule, backup retention period and how to restore the cluster

Отказоустойчивость кластера

Роль мастер-ноды и реплик в кластере, как изменить количество реплик

Configure network access to the cluster

How to restrict access to the cluster from certain addresses for security purposes

Public IP address

How to connect a public IP address to a PostgreSQL cluster node for 1C

Create a network with a dedicated server

How to create a network with a dedicated server

Migration to cloud databases

How to migrate PostgreSQL database to cloud databases