Run PostgreSQL on Ubuntu in your own AWS account, with your database, user and backups to Amazon S3 set up when the stack launches.
PostgreSQL is a free, open-source object-relational database. It supports both relational (SQL) and JSON queries, which makes it a common choice for web applications and data-heavy services.
Relational queries and JSON documents in one database.
Transactions and constraints you can rely on.
Extensions, custom types and functions.
Connect with pgAdmin, psql or any PostgreSQL driver.
Database backups go to a bucket in your own account.
Decades of development and a large ecosystem.
The AMI ships PostgreSQL configured from your stack parameters, with backups to S3 set up.
Make an S3 bucket in your account for the database backups.
Subscribe on AWS Marketplace and launch the stack with your database name, user, password and bucket.
Limit DatabaseSSHLocation and SSHLocation to your own IP ranges instead of 0.0.0.0/0.
After 5-10 minutes, connect to the PublicIp on port 5432 with your user and password, for example from pgAdmin.
An AMI on AWS Marketplace, launched into your own AWS account with a CloudFormation stack.
Launch on AWS Restrict both ports to the IP ranges that need them.
| Service | Ports | Protocol |
|---|---|---|
| PostgreSQL | 5432 | TCP |
| SSH (administration) | 22 | TCP |
Server size: t3.small to start. Size the instance to your database and workload.
A free, open-source object-relational database that supports both SQL and JSON queries.
Use the PublicIp from the stack outputs as the host, port 5432, and the PostgresqlUser and PostgresqlPassword you set, for example in pgAdmin.
To the S3 bucket you name when creating the stack, inside your own AWS account.
No. Restrict the database and SSH source ranges to the addresses that need them.
It lets you choose exactly which region your database and backups live in. You still need your own access controls and processing records.
t3.small is the recommended starting point; size up with your data and workload.
Back up your data, remove the old stack and launch the new version from AWS Marketplace.
Scheduled backups and retention for PostgreSQL.
Launch the stack and connect to your database.
Put dashboards on top of your PostgreSQL data.
We build and run self-hosted databases every day, from backup strategy to performance tuning. Tell us what you need.
Contact us