ThePlanMinder PostgreSQL

Last edited on 7 Dec 2022 • Generated on 25 Oct 2024

This page is automatically generated from the DigitalOcean Marketplace using content on the ThePlanMinder PostgreSQL catalog page.

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 www.theplanminder.com

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.

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"}' \
        "https://api.digitalocean.com/v2/droplets"

Getting Started After Deploying ThePlanMinder PostgreSQL

ssh root@your_droplet_public_ipv4

Type

bash create_db.sh

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 theplanminder.com.

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 create_db.sh script again to create additional databases for The PlanMinder on the droplet.