You get a real PostgreSQL 18 database with its own owner login — not a schema in somebody
else’s database. The engine features you rely on are there, and the tools around it are
in the Control Panel.
Engine features
- JSONB with GIN indexes for document-style data
- Full-text search with
tsvector and tsquery
- CTEs, window functions and generated columns
- PL/pgSQL functions, procedures, triggers and views
- Trusted extensions such as
pg_trgm, citext, pgcrypto, uuid-ossp, hstore, unaccent and ltree, enabled with CREATE EXTENSION
Developer experience
- Connection strings in the Npgsql format, ready to copy into
appsettings.json
- Works with Entity Framework Core, Dapper and plain Npgsql
- Supports migrations from
dotnet ef database update
- Separate read+write or read-only users for each application
- Run SQL in the browser, or open WebPGSQL with no client installed
Connection pooling
All connections, local and remote, go through PgBouncer in transaction pooling mode. Npgsql works without any changes. A few session-level features do not work through the pooler: LISTEN / NOTIFY, session advisory locks, WITH HOLD cursors and SET outside a transaction. Use SET LOCAL, pg_advisory_xact_lock() or ALTER ROLE ... SET instead. A transaction that stays idle for more than 5 minutes is terminated, and each database has a limit of 100 connections.
Remote access for pgAdmin and CI/CD
Remote access is a switch in the Control Panel. Once it is enabled, you connect to the public hostname of your database on port 5432 with SSL from pgAdmin, DBeaver, psql or your CI/CD pipeline; additional users work over remote access too. Websites hosted with us use the local server name and reach the database over our internal datacenter network.
Backups and restore
A backup is a pg_dump in the custom format. Create one at any time and download the .dump file, or upload your own dump of up to 2 GB and restore it — with an optional safety backup of the current data first. A downloaded backup can be restored on any PostgreSQL server with pg_restore, so your data is never locked in.
Limits by plan
- Free plan: 1 GB database storage, 1 database (EU datacenter)
- Premium Single: 2× databases × 2 GB each
- Premium Multi: 10× databases × 2 GB each
- Add-on: extend any Premium database in 2 GB blocks