Managed PostgreSQL
Serverless PostgreSQL cluster
PostgreSQL on Northflank
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:
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.
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.
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.
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.
On the backups page you can create, import, and delete backups of your 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.
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.
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.
