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.