Creating a Database
You can provision PostgreSQL in two ways: as a standalone service or as an addon attached to an existing app.Standalone Service
- Open app.miget.com and go to Services.
- Click Create your first service (or New service) and pick PostgreSQL, then choose Configure.
- Assign a Resource (the compute pool where the database will run) and give the service a descriptive Name/Label.
- Customize the database:
- Pick the PostgreSQL version (see supported list below).
- Toggle Public Access on/off depending on whether you need external connectivity.
- Optionally add project-scoped environment variables such as
DATABASE_URLso every app in the project can reuse the connection string.
App Addon
If you already have an app, open it and select Addons → PostgreSQL → Add. The same configuration form appears with identical options (version, public access, environment variables). When created as an addon, Miget automatically injects app-level environment variables so your app can immediately consume the connection details.
- 17.x
- 16.x
- 15.x
- 14.x
- 13.x (maintenance only)
You receive the latest patch for the chosen major line, e.g., 17.1 for the 17.x track.
Memory Profiles
Managed Miget’s PostgreSQL instances are pre-configured with memory profiles. Miget PostgreSQL plans ranging from 128 Mi to 8 Gi. If you need more - we can always work with you to provide a custom plan; just contact us at hello@miget.com| RAM | max_connections | shared_buffers | effective_cache_size | maintenance_work_mem | work_mem |
|---|---|---|---|---|---|
| 128 Mi | 97 | 32MB | 96MB | 8MB | 84kB |
| 256 Mi | 97 | 64MB | 192MB | 16MB | 168kB |
| 512 Mi | 97 | 128MB | 384MB | 32MB | 337kB |
| 1 Gi | 97 | 256MB | 768MB | 64MB | 675kB |
| 2 Gi | 97 | 512MB | 1536MB | 128MB | 1351kB |
| 4 Gi | 97 | 1GB | 3GB | 256MB | 2702kB |
| 8 Gi | 197 | 2GB | 6GB | 512MB | 2661kB |
Connecting to Your Database
How you connect to your database depends on your code: some frameworks expect a single connection string or URL in an environment variable, while others need multiple connection parameters in a configuration file.When you add a PostgreSQL addon, Miget will automatically generate and set a
DATABASE_URL variable with a value like postgres://fcsn1vo8:PXERTRrlRhTb@postgres-t7hvtfin.migetcyy.eu-east-1.migetapp.internal:5432/t7hvtfin. This means you don’t have to manually configure your database connection—Miget handles it for you, ensuring the connection details are securely stored and easily accessible by your application during runtime.Connecting from Apps on Miget
Using internal connection values is the recommended way for workloads running inside Miget. The hostname, username, database, and password are displayed on the service or addon page:
postgres://fcsn1vo8:PXERTRrlRhTb@postgres-t7hvtfin.migetcyy.eu-east-1.migetapp.internal:5432/t7hvtfin is also available if needed. Many database frameworks allow (or require) a connection string instead of individual connection parameters.
Connecting from Outside Miget
If Public Access is enabled, the Connection Information panel lists:- An External Connection URL (standard PostgreSQL URI)
-
A ready-to-run psql command, for example:
Backups
We take complete database backups every day and retain all backups for at least 7 days.Disk Space
We offer PostgreSQL plans ranging from 128 Mi to your current Miget plan’s limit of storage per instance. The database storage limit applies to all storage the PostgreSQL database needs, including caches, indices, etc. Backup storage does not count toward your plan’s storage limit. If you need more - we can always work with you to provide a custom plan; just contact us at hello@miget.comMetrics
Dashboard
You can view database metrics any time in the Miget Dashboard. Currently, we support the following:| Metric | Description |
|---|---|
| CPU | The amount of CPU used |
| Memory | The amount of memory used |
Database Versions & Upgrades
Miget currently supports PostgreSQL 13, 14, 15, 16 and 17. You can select the major version of your database at creation time, after which it cannot be changed. We will periodically upgrade the minor version of your databases to apply the latest security fixes. For any maintenance periods that require downtime, we email you ahead of time. We also allow you to run the maintenance yourself, simply stop and start your database from the Miget Dashboard. A newer Docker image of PostgreSQL will run your database.Upgrading to a New PostgreSQL Major Version
Here’s an overview of the process for upgrading your database to a newer PostgreSQL version:- Set up a new database instance with the desired version.
- Stop any applications that write to the current database to avoid discrepancies between the existing data and the backup.
- Create a backup of your current database.
- Restore the backup to the new database instance.
- Update your applications to connect to the new database and resume their operation.
pg_dump command. Replace variables with your connection details (internal or public hostname):
Deleting Databases
If you choose to delete a PostgreSQL instance, we do not keep any backups or snapshots of your data. Be sure to download a backup before proceeding with deletion.PostgreSQL Extensions
Miget PostgreSQL databases support many popular extensions, such aspgvector, postgis, and others. The specific PostgreSQL version of your database determines which extensions are available and how they can be added.
To enable any supported extension, run the CREATE EXTENSION command, for example:
psql session using either the internal hostname or the external connection URL, for example: