How does it work?
A core of the Managed PostgreSQL architecture is a PostgreSQL server. Each server is an instance of the PostgreSQL relational database management system. The server hosts the PostgreSQL engine, which processes SQL queries, manages data storage, and handles other database-related tasks. Once a PostgreSQL server is configured and provisioned, it is ready for use. The server’s configuration — including flavor, connection pooler mode, volume type, and more — can be tailored to the specific needs of the application and workload. Within each server, multiple relational databases can be created. Users and applications interact with the server to store, retrieve, and manipulate data, while the underlying infrastructure handles server maintenance and management tasks.Supported versions
Gcore Managed PostgreSQL currently supports PostgreSQL 13, 14, and 15.Key features
Gcore Managed PostgreSQL offers the following advantages:- Managed infrastructure: Gcore handles the infrastructure, ensuring the database runs smoothly and securely.
- Flexible instance configuration: Database instances can be customized by choosing the vCPU/RAM size, storage capacity, and database configuration to match specific load requirements.
- High availability: Deploy up to two additional replicas to fail over if the primary server goes down. Synchronous replication mode is available for increased data consistency.
- Security: Access to data can be restricted to specific IP addresses via the access control list.
- Wide geography: A wide range of data center locations is available, ensuring low-latency access for users across the globe.
Use cases
Managed PostgreSQL is a good fit for a range of industries and workloads:- Web applications: Web and mobile app developers can manage databases for their projects more efficiently.
- Analytics: Data analytics and business intelligence applications benefit from scalable, high-performance databases.
- IoT (Internet of Things): Managed PostgreSQL supports the storage and analysis of large volumes of data generated by IoT devices.
- E-commerce: Online retailers can use Managed PostgreSQL to handle large product catalogs and customer data.