Install PostgreSQL with phpPgAdmin on Ubuntu 16.04

 In Dedicated, VPS, Web

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:

postgres@vps:~$ psql

Change your ‘postgres‘ role password to match your needs:

postgres=# \password postgres

Enter the new password when prompted.

Quit the psql command line:

postgres=# \q

Exit the postgres user:

postgres=# exit

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 file:

# nano /etc/phppgadmin/

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.

Recommended Posts

Start typing and press Enter to search