ThePlanMinder PostgreSQL

PostgreSQL 12 server with a script to quickly create a database for The PlanMinder. With afw firewall and fail2ban configured and ready to use.

This Droplet is intended as a server for The PlanMinder project planning software available at

A Basic 1 GB / 1 CPU plan should be enough for most users. You can upgrade later if needed.

Software Included

Package Version License
PostgreSQL 12 PostgreSQL License

Creating an App using the Control Panel

Click the Deploy to DigitalOcean button to create a Droplet based on this 1-Click App. If you aren’t logged in, this link will prompt you to log in with your DigitalOcean account.

Deploy to DO

Creating an App using the API

In addition to creating a Droplet from the ThePlanMinder PostgreSQL 1-Click App using the control panel, you can also use the DigitalOcean API. As an example, to create a 4GB ThePlanMinder PostgreSQL Droplet in the SFO2 region, you can use the following curl command. You need to either save your API access token) to an environment variable or substitute it in the command below.

curl -X POST -H 'Content-Type: application/json' \
         -H 'Authorization: Bearer '$TOKEN'' -d \
        '{"name":"choose_a_name","region":"sfo2","size":"s-2vcpu-4gb","image": "auspiciaab-theplanminderpos-20-04"}' \

Getting Started After Deploying ThePlanMinder PostgreSQL

Login as root with SSH, or use the web console.

ssh root@your_droplet_public_ipv4



to create a database user login and a database for The PlanMinder.

After creation the script will display the information needed to connect to the database with The PlanMinder. When starting The PlanMinder client on your PC, make sure the service user tab is marked in the login window. The PlanMinder will ask you if you want to create database tables. You should answer yes to complete the database setup.

A detailed step by step guide is available at

Additional details

The firewall is open for SSH at port 22, and for Postgres at port 35432.

The “postgres” database user is not allowed to connect remotely. This can be changed by editing the /etc/postgresql/12/main/pg_hba.conf file.

You can create a firewall in the Digital Ocean Networking section to limit access to the droplet to known source ip numbers.

You can run the script again to create additional databases for The PlanMinder on the droplet.