PostgreSQL

PostgreSQL

Official Preset16

Category: Databases & BaaS

#database#sql#relational#postgres#acid#open-source

Overview

PostgreSQL is a powerful, open-source object-relational database system with over 35 years of active development. It has earned a strong reputation for proven architecture, reliability, data integrity, robust feature set, and extensibility. Deploying PostgreSQL with tug.sh gives you isolated persistence, automated volume backups, and custom connection pooling out of the box without cloud lock-in.

Primary Use Cases

1

Primary transactional database for modern web, SaaS, and mobile applications

2

Complex queries, financial transactions, and relational data structures

3

Geo-spatial applications with PostGIS extension

4

Time-series and analytics storage alongside relational tables

Key Features

  • Full ACID compliance & robust transaction management
  • Native JSON and JSONB indexing for hybrid document storage
  • Rich extension ecosystem including pgvector, PostGIS, and TimescaleDB
  • Point-in-Time Recovery (PITR) and streaming replication
  • Fine-grained role-based access control and security

Container Specification

Docker Image

postgres:16

Default Version

16

SSL & Domain Routing

Automated Let's Encrypt (Caddy / Traefik)

Persistent Volumes

Managed host volume mounts

How to Deploy PostgreSQL with tug.sh

1

Connect your Linux server

Run the 1-line tug.sh agent install command on any Ubuntu, Debian, or Rocky Linux VPS.

2

Select PostgreSQL from the Marketplace

Pick your domain name, configure custom environment variables if needed, and choose your persistent storage folder.

3

Click Deploy & Go Live

tug.sh pulls the container, sets up HTTPS certificates, configures the reverse proxy, and boots the service in under 60 seconds.