Installing PostgreSQL for better performance and data integrity in our wifi hotspot machines

Using PostgreSQL as our database have many advantages which includes concurrent connections, data integrity, security and more.

Step 1: Install Postgre SQL

sudo apt update
sudo apt install postgresql postgresql-contrib -y

Step 2: Configuring Database

sudo -u postgres psql

Let’s set our password:

postgres=# \password
Enter new password: 
Enter it again: 
postgres=# \q

Let’s create our database:

sudo -u postgres createdb adopisoft

Then reload and enable postgres service:

sudo service postgresql reload && \
  sudo systemctl enable postgresql.service

Step 3: Configure Your Machine

Login to your admin dashboard and go to System > Security and enter the database connection details:

After everything saving your new database settings, reboot your machine.

Categories: article