PostgreSQL Server

PostgreSQL at a glance

Category

Database (database)

Docker image

postgres:16-alpine

Default version

16

Ports

5432/TCP

RAM

1 GB

CPU

1 core

Disk

20 GB

Console

Interactive console (stdin)

Template version

v1.0.0

PostgreSQL server ports

A PostgreSQL server built from this template listens on this port. Open it in your firewall so players and clients can connect.

sudo ufw allow 5432/tcp

PostgreSQL server requirements

These are the template's recommended starting values. Increase it as your data and number of connections grow.

Run PostgreSQL in Docker

The template uses the postgres:16-alpine image, default version 16. NautilusControl pulls it automatically; to fetch it yourself:

docker pull postgres:16-alpine

docker-entrypoint.sh postgres

PostgreSQL settings (environment variables)

You can change these when you create the server or later in its settings.

Files and folders

• /var/lib/postgresql/data — Data

How to set up a PostgreSQL server with NautilusControl

1. 1

   Install NautilusControl

   Install the NautilusControl panel and agent on the machine that will run the server. The installation guide covers it, and the 14-day free trial includes 1 node and 5 servers.

2. 2

   Import the PostgreSQL template

   Download this template (a single JSON file) with the button above, then open Templates in NautilusControl and choose Import JSON.

3. 3

   Create the server

   Create a new container and pick PostgreSQL. NautilusControl pulls postgres:16-alpine, fills in the environment variables listed below, and creates the folders for you.

4. 4

   Open the ports

   Allow port 5432 through your firewall, and forward it on your router if people connect from outside your network.

5. 5

   Start it

   Press Start and follow the startup log in the panel, then use the interactive console (stdin) for commands.

Server files come from www.postgresql.org.

Notes

Advanced open-source relational database. Used by GitLab, Mastodon, and many modern apps. Connect with postgresql://user:pass@host:5432/dbname

PostgreSQL FAQ