Installing PostgreSQL
Installing PostgreSQL for better performance and data integrity in our wifi hotspot machines
Step 1: Install Postgre SQL
sudo apt update
sudo apt install postgresql postgresql-contrib
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.