Architecture
A PostgreSQL server is the core unit of Gcore Managed PostgreSQL. It runs the PostgreSQL engine, which processes SQL queries and manages data storage, and can host multiple relational databases. Each server’s configuration — flavor, connection pooler mode, volume type, and more — can be adjusted to match the application’s workload requirements.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 configuration: Servers 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 for failover if the primary server becomes unavailable. 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: The managed infrastructure and automatic maintenance remove the operational overhead that typically slows development teams.
- Analytics: The configurable vCPU/RAM and storage capacity let analytics workloads scale to their query volume without changing application code.
- IoT: High-throughput write workloads from IoT devices benefit from the adjustable storage and connection pooler, which reduces connection overhead at scale.
- E-commerce: The access control list restricts database access to specific IP addresses, reducing the attack surface for applications that handle sensitive customer data.