Install PostgreSQL with phpPgAdmin on Ubuntu 16.04
1. Log in to your server via SSH
# ssh root@server_ip
You can check whether you have the proper Ubuntu version installed on your server with the following command:
# lsb_release -a
You should get this output:
Distributor ID: Ubuntu Description: Ubuntu 16.04.1 LTS Release: 16.04 Codename: xenial
2. Update the system
Make sure your server is fully up to date using:
# apt-get update && apt-get upgrade
3. Install PostgreSQL and phpPgAdmin on Uubntu 16.04
Now install PostgreSQL and phpPgAdmin using the below command:
# apt-get install postgresql postgresql-contrib phppgadmin
This command will install all the necessary packages needed by PostgreSQL and phpPgAdmin such as Apache, PHP etc… so don’t worry if you don’t have Apache or PHP installed on your server.
4. Log into the Postgrees System Account
Once the installation is completed, log into the ‘postgres‘ system account so you can access PostgreSQL. Type:
# su - postgres
Now you can access PostgreSQL using:
Change your ‘postgres‘ role password to match your needs:
postgres=# \password postgres
Enter the new password when prompted.
Quit the psql command line:
Exit the postgres user:
5. Configure Apache
In order to access phpPgAdmin via your browser, the Apache web server needs to be configured. Therefore open the phppgadmin.conf file:
# nano /etc/apache2/conf-available/phppgadmin.conf
Comment the ‘Require local‘ line by adding ‘#’ in front of the line. Then under that very line, add ‘Allow From all‘. Save and close the file. After editing the section should look like this:
# Only allow connections from localhost: #Require local Allow From all
Now tweak some settings for phpPgAdmin. Open the config.inc.php file:
# nano /etc/phppgadmin/config.inc.php
Locate the ‘$conf[‘extra_login_security’] = true;‘ and change the value from true to false so you can log in to phpPgAdmin as the postgres user.
Save and close the file.
6. Restart PostgreSQL and Apache
Now restart PostgreSQL and Apache. Then enable them to start on boot. All of this can be done using the below 4 commands:
# systemctl restart postgresql # systemctl restart apache2 # systemctl enable postgresql # systemctl enable apache2
7. Verify phpPgAdmin Installation on Ubuntu 16.04
Now open your favorite web browser and access phpPgAdmin by navigating to http://your_server_IP/phppgadmin/. You will be welcomed by a page as shown in the image below:
You can log in using the postgres user and the password you’ve configured previously. Now use this great tool to create and manage databases in PostgreSQL.