Our Managed Database service for PostgreSQL provides a secure, scalable, and maintenance-free environment for your applications. Each instance includes a pre-created database, supporting one database per instance, which is automatically provisioned at the time of creation. It's the ideal solution for teams looking to streamline operations and focus on development without managing infrastructure. Read more
Locations
The product is present in the following locations:
- dc-fbg1 (our DC in Falkenberg, Sweden)
- dc-sto1 (our DC in Stockholm, Sweden)
- dc-oul1 (our DC in Oulu, Finland)
Technical Specification
| Customer self-service | Yes. Managed in Glesys Cloud and available via API |
| Engine version(s) | PostgreSQL version 16 |
| Disk IOPS | 12,000 |
| PostgreSQL extensions | See list of supported extensions below |
| Database replication feature | No |
| Automated failover feature | No |
| Change engine version support | No |
| Root user privileges | No |
| User-specific database permissions | No |
| Encryption at Rest | No |
| Encryption in Transit | Yes (uses the TLS protocol) |
| Availability and access | By default, all traffic is blocked. As a user, you add IP addresses that are allowed to connect to the database. |
| Disk full failure prevention | Database instances automatically switch to read-only mode when the disk is almost full, with 3 GiB remaining. Preventing writes stops the disk from continuing to fill and keeps the instances available for reads. During the read-only mode, you can take measures to free more disk space. |
| Processing of personal data | Storage, transfer |
Automated backup
| Backup plan | One daily backup with 14-days retention |
| Custom schemes | No |
| Remote backups | Yes |
| Point-in-time recovery (PITR) | No |
Predefined plans
Glesys offers a wide spectrum of plans to serve use cases that range in size from personal blogs to large datasets and high-transaction applications.
Please note that there is currently no feature in the UI to switch plans. However, users can utilize a SQL dump provided by us and restore it to a new instance with the desired resources.
| vCPUs | Memory | Storage | Max. Connections |
|---|---|---|---|
| 1 | 4 GiB RAM | 25 GiB | 100 |
| 1 | 4 GiB RAM | 50 GiB | 100 |
| 2 | 8 GiB RAM | 50 GiB | 200 |
| 2 | 8 GiB RAM | 100 GiB | 200 |
| 4 | 16 GiB RAM | 50 GiB | 400 |
| 4 | 16 GiB RAM | 100 GiB | 400 |
| 4 | 32 GiB RAM | 150 GiB | 800 |
| 4 | 32 GiB RAM | 300 GiB | 800 |
| 8 | 64 GiB RAM | 150 GiB | 1,600 |
| 8 | 64 GiB RAM | 300 GiB | 1,600 |
| 8 | 128 GiB RAM | 150 GiB | 3,200 |
| 8 | 128 GiB RAM | 300 GiB | 3,200 |
Monitoring
Monitoring is available via a Prometheus-compatible endpoint; however, customers must set up their own solution to store historical metrics. Access to systemd logs and the slow query log is not available.
Maintenance
You will be assigned a regular and recurring day and time each week for maintenance. Occasionally, Glesys performs maintenance tasks on the managed PostgreSQL database. These tasks typically include updating the underlying infrastructure of the database, such as patching the operating system, updating necessary libraries, or upgrading PostgreSQL itself. Glesys manages these maintenance tasks automatically. During maintenance, the database may experience a brief period of downtime, which can last up to 10 minutes.
Responsibilities
| Infrastructure platform | Glesys |
| Database administration | Customer |
| SQL troubleshooting | Customer |
| PostgreSQL performance troubleshooting | Customer |
| Automated backups | Glesys |
| Backup verification | Customer |
| Backup recovery* | Customer |
Supported PostgreSQL extension
PostgreSQL extensions enable you to enhance the functionality of your Managed Databases for PostgreSQL by adding more capabilities.
- address_standardizer
- address_standardizer_data_us
- bloom
- bool_plperl
- btree_gin
- btree_gist
- citext
- cube
- dblink
- earthdistance
- fuzzystrmatch
- h3
- h3_postgis
- hll
- hstore
- intagg
- intarray
- isn
- jsonb_plperl
- lo
- ltree
- pageinspect
- pg_buffercache
- pg_cron
- pg_partman
- pg_prewarm
- pg_repack
- pg_similarity
- pg_stat_statements
- pg_trgm
- pgcrypto
- pgrowlocks
- pgstattuple
- pgvector
- pgrouting
- plperl
- plpgsql
- postgis
- postgis_legacy
- postgis_raster
- postgis_sfcgal
- postgis_tiger_geocoder
- postgis_topology
- postgres_fdw
- rum
- seg
- sslinfo
- tablefunc
- tcn
- tsm_system_rows
- tsm_system_time
- unaccent
- unit
- uuid_ossp