Setup PostgreSQL

Now we are going to setup PostgreSQL database that our Payload website will use.

Go to ''Stacks' in Portainer and click '+ Add stack'.

Call it something meaningful like 'postgresdb'.

Paste in the web editor:

version: "3.9"services:  postgresdb:    image: postgres:latest    deploy:      replicas: 1   # Restrict to a single replica    restart: always    environment:      POSTGRES_USER: myusername      POSTGRES_PASSWORD: mypassword    ports:      - "5432:5432"    networks:      - shared_network    volumes:      - pg_data:/var/lib/postgresql/data​volumes:  pg_data:​networks:  shared_network:    external: true

Replace the myusername and mypassword with whatever you would like to use.

This is set to publish the default port of 5432, if you want to change that then update to "<whateverportnumber>:5432".

You will be able to connect to this database using your database GUI of choice, such as PGAdmin, by using your Tailscale IP address, port number, user and password. We will be locking down access from the main public IP later in this guide, so its only accessible over your Tailscale network.