🧩 Installing and Configuring PostgreSQL for Mango

This guide provides detailed steps to install and configure PostgreSQL for use with Mango OS. You will install PostgreSQL, create a dedicated Mango database and user, and validate Mango’s connection to ensure data is written properly.

🔍 Overview

• Install and initialize PostgreSQL
• Secure the default postgres role
• Create a mango database and user
• Verify permissions and connectivity
• Point Mango to PostgreSQL via mango.properties

🛠 Part 1: PostgreSQL Installation

1. Switch to Superuser

   sudo su
   

2. Install PostgreSQL Server and Tools

   dnf install postgresql-server postgresql-contrib
   

3. Initialize the Database

   postgresql-setup --initdb
   

4. Enable and Start PostgreSQL Service

   systemctl enable postgresql
   systemctl start postgresql
   

5. Verify Installation

   psql --version
   

🔐 Part 2: Secure PostgreSQL and Set Password

1. Switch to the PostgreSQL User

   su - postgres
   

2. Open the PostgreSQL Shell

   psql
   

3. Set the Password for the postgres Role

   \password postgres;
   

   Choose a strong password and store it securely (e.g., Keeper). Exit when finished:

   \q
   

🧱 Part 3: Create Database and User for Mango

1. Log in as postgres

   su - postgres
   psql
   

2. Create Mango Database and Role

   CREATE DATABASE mango;
   CREATE ROLE mango WITH LOGIN PASSWORD 'putthepasswordhere';
   GRANT ALL PRIVILEGES ON DATABASE mango TO mango;
   \q
   

3. Optional: Adjust pg_hba.conf for Local Access

   Edit the file (path may vary by distro; on RHEL-family it’s typically /var/lib/pgsql/data/pg_hba.conf):

   vi /var/lib/pgsql/data/pg_hba.conf
   

   Ensure the following line allows local password authentication:

   local   all             all                                     md5
   

4. Reload PostgreSQL

   systemctl restart postgresql
   

✅ Part 4: Verify Database Permissions

1. Test Login with Mango User

   psql -U mango -d mango -W
   

2. Run Basic SQL Commands

   CREATE TABLE test_table (test_id INT);
   INSERT INTO test_table (test_id) VALUES (1);
   SELECT * FROM test_table;
   DROP TABLE test_table;
   \q
   

   If all commands succeed, the Mango user has proper privileges.

🔁 Part 5: Connect Mango to PostgreSQL

1. Edit the mango.properties file and update the database connection settings:

   db.type=postgres
   db.url=jdbc:postgresql://localhost:5432/mango
   db.username=mango
   db.password=putthepasswordhere
   

2. Start Mango

   systemctl start mango
   

3. Verify Mango is Writing to PostgreSQL

   psql -U mango -d mango -W
   SELECT * FROM events LIMIT 5;
   

   ✅ You should see at least one startup event listed.

🧾 Summary

• Installed and initialized PostgreSQL
• Secured the default postgres role
• Created the mango database and user
• Connected Mango to PostgreSQL
• Verified data writes

🔗 References

• Radix IoT Support Portal: https://support.radixiot.com
• PostgreSQL Documentation: https://www.postgresql.org/docs/
• Mango OS: https://radixiot.com/mango