PostgreSQL

Database as a Service for PostgreSQL

Managed PostgreSQL

PostgreSQL is an open-source object-relational datastore which allows storing and querying data in a structured manner. PostgreSQL supports both SQL, relational, and JSON, non-relational, querying.

Serverless PostgreSQL cluster

Easily spin up a PostgreSQL cluster and only pay for the resources you consume. Benefit from automatic patching and upgrading of your PostgreSQL clusters. Effortlessly scale replicas and compute when demand requires. Northflank completely automates your database management including logs, metrics, backups and restores in a container based deployment.

As things start to scale, select from a range of plans starting at $2.70 per month.

PostgreSQL versions supported: 14.1.0, 13.5.0, 12.9.0, 11.14.0

Need to deploy on your Kubernetes cluster? Click here.

PostgreSQL on Northflank

Ready for scale

Horizontal and vertical scaling with replicas and increased compute capacity.

Backups and restores

Create, import, and delete backups, as well as restore your database from an existing backup.

Observe and Monitor

Observe your database in real-time with log tailing and performance metrics.

Pause and resume

Pause and restart your running PostgreSQL database at any time enabling experiments and dev databases.

Advanced networking

Secure private network, enable public load-balancing and connect locally with Northflank CLI proxy.

TLS and secure connection

Connect your workloads to PostgreSQL securely with TLS and generated connection details.

PostgreSQL on Northflank dashboard

PostgreSQL use cases

Robust back-end database
Geospatial datastore
In the financial industry, for OLTP (Online Transaction Processing)
Analytics

Supported PostgreSQL versions

14.1.0
13.5.0
12.9.0
11.14.0

PostgreSQL Docker Image

postgres:latest

Pull PostgreSQL Docker Image locally

docker pull postgres

Connect to PostgreSQL locally with Northflank CLI

sudo northflank forward addon --projectId --addonId

PostgreSQL Ports

5432

Using the PostgreSQL client to connect to remote PostgreSQL instance

psql "postgresql://username:password@hostname:5432/database?sslmode=require"

Platform Teams

Northflank makes it easier for infrastructure and platform teams to focus on levelling up the developer experience for their teams building great apps.

Common PostgreSQL questions among developers and platform teams:

How to securely connect to a PostgreSQL database from developer workstations?

You can access a PostgreSQL database from your machine using the Northflank CLI. To forward a specific database or storage: sudo northflank forward addon --projectId [project-name] --addonId [addon-name] You can now access the database or storage locally.

How to set up an external connection outside of the cluster?

When creating an addon, under Networking you can choose “Publicly accessible”. Once the addon is created, you can make the addon publicly accessible from the Settings page. If “Publicly accessible” is selected, your addon will be given a public URL and will be accessible from the internet.

How to provision SSL and TLS for a database?

When creating an addon, under Networking you can choose “Deploy with TLS”. Once the addon is created, you can provision SSL and TLS from the Settings page by choosing “Deploy with TLS”. If “Deploy with TLS” is selected, a Let’s Encrypt TLS certificate will be provisioned for your addon, allowing secure communication between the addon and your services/jobs within this project.

How to scale a PostgreSQL deployment with more replicas or resources?

When creating an addon, under resources you can choose the compute plan (memory and virtual CPU), storage and replicas. Once the addon is created, under resources you will always be able to change these to adapt to your needs.

How to backup a PostgreSQL cluster?

On the backups page you can create, import, and delete backups of your PostgreSQL cluster.

How to restore a PostgreSQL cluster?

You can restore your database from an existing backup from the backups page. This page will display a list of backups and each entry will have a Restore button you can use to restore from that selected backup. The backup will be scheduled and executed shortly.

How to import from another PostgreSQL cluster?

You can import a backup from multiple sources: URL, file upload, and connection string. When importing from a URL or file upload, Northflank will treat it as clear text, unless the file ends in.gz, then Northflank will attempt to unzip it. When importing from a connection string, it should contain the relevant credentials and parameters. Northflank will create a dump from the source database which you can then restore from.

How to fork a PostgreSQL cluster?

To fork a PostgreSQL cluster, you can create a backup of an existing PostgreSQL addon from the backups page and create a new addon using this backup.

PostgreSQL on Kubernetes with Northflank

Deploying PostgreSQL onto Kubernetes can be difficult to bootstrap, operate and scale. Your current options may involve manually rolling PostgreSQL Helm charts, YAML, statefulsets, replicasets, services, persistent volumes, ingress, Horizontal Pod Autoscaling (HPAs), Pod Disruption Budgets (PDBs), prometheus metrics, certificates and logging.

Northflank offers a comprehensive stateful workload solution. Run a highly scalable and performant PostgreSQL database in your AWS, GCP and Azure accounts using Kubernetes and Northflank’s platform.

PostgreSQL DBaaS or PostgreSQL in your cloud

Automate your PostgreSQL hosting and management using a real-time UI and developer friendly CLI & API. Deploy, monitor, backup, and scale with Northflank cloud or on your cloud account.

PostgreSQL creation on Northflank dashboard