Our droplets are Linux based virtual machines where you receive root (administrator) access and can install whatever software you like. To install a stack including Apache, PHP and PostgreSQL you could create a new Ubuntu 14.04 droplet, log in and run the following commands:
apt-get install apache2 php5 install postgresql postgresql-contrib php5-pgsql libapache2-mod-php5
You will need to then create a database user and configure Postgre, this guide will walk you through that. When complete your web root (where to put your php files) will be
If you would prefer to use php 7, I would recommend using an Ubuntu 16.04 droplet and in the command above, replace “php5” with “php7.0” in all the package names.
PostgreSQL is one of the most powerful and popular relational database management systems available for open source platforms. In this guide, we'll talk about how to get it up and running on an Ubuntu 14.04 VPS instance.