Using 1C:Enterprise
Delphi Managed Service for PostgreSQL
A service for managing clusters of the popular PostgreSQL object-relational DBMS in the Delphi Cloud infrastructure.
Optimal configuration
You can deploy a ready-to-use cluster in just a few minutes. DB settings are optimized for the selected cluster size and you can change them if necessary.
Easy scaling
If the load on your cluster increases, you can add new servers or increase their capacity in a matter of minutes.
Restore to any point in time
With Point-In-Time Recovery, you can restore your database to any point in time during the last seven days.
Cluster performance diagnostics
With a user-friendly interface and intuitive visualization, you can monitor the status of your PostgreSQL cluster and DB load.
Data security
All DBMS connections are encrypted using the TLS protocol, and DB backups are GPG-encrypted. Data is secured in accordance with the requirements of local regulatory, and ISO industry standards.
SQL queries in the management console
Visualize the data structure in your PostgreSQL cluster and send SQL queries to databases from the management console.
Implement your projects using Managed Service for PostgreSQL
Financial accounting
Integration with location-based services
Storage of complex data structures
We’ll take care of most of database maintenance
Processes
Managed Service for PostgreSQL
Data access control
Managed Service for PostgreSQL
Network configurations
Managed Service for PostgreSQL
OS and software installation
Managed Service for PostgreSQL
DBMS updates
Managed Service for PostgreSQL
Backup and recovery
Managed Service for PostgreSQL
Data replication setup
Managed Service for PostgreSQL
Data storage and hardware security
Managed Service for PostgreSQL
Integration with Delphi Cloud services
Managed Service for PostgreSQL
Monitoring tools
Managed Service for PostgreSQL
VM deployment
Independent control
How do I get started with PostgreSQL
To get started, go to the Delphi Cloud console and create a PostgreSQL database cluster. You can set characteristics, choose a host class and storage size, and select the network to connect your cluster to as well as an availability zone.
Create cluster
Save up to 22% with reserved managed databases
Get up to 22% in savings on managed databases in the cloud — just reserve resources for six months or a year in advance, right in the management console.
Learn more
Questions and answers
PostgreSQL is an open-source object-relational DBMS that is highly reliable, easy to scale, and often used in financial accounting or as a backend database for web services.
The list of versions is available in the documentation.
When creating clusters, Managed Service for PostgreSQL allocates resources, installs the DBMS, and creates databases. For created and running databases, it automatically creates backups and applies fixes and updates to the DBMS. The service also provides data replication between database hosts and automatically switches the load over to a backup replica in the event of a failure.
Yes. The service lets you visualize the data structure in your PostgreSQL cluster and send SQL queries to databases from the Delphi Cloud management console.
Our Performance Diagnostics tool helps you answer the following major questions: How many resources did each of the query types consume at a specific point in time? Why did queries made at a particular time take longer to process? How many queries were executed in the DB over a certain period of time, what were these queries, and how long did they take to complete? Comparison of two intervals by the number of queries and their execution time. The Performance Diagnostics tool stores data for the last 2 weeks.