Ubuntu 16.04 LAPP Setup: Difference between revisions

From myWiki
Created page with "Install Apache sudo apt-get install apache2 Install Postgresql sudo apt-get install postgresql Install PHP 7.0 sudo apt-get install php sudo apt-get install php7.0-pgsql"
 
No edit summary
Line 5: Line 5:
Install Postgresql
Install Postgresql


  sudo apt-get install postgresql
  sudo apt-get install postgresql postgresql-contrib
 
The contrib is used with PGadmin III. The install creates a system user account: postgres
 
Change O/S user to postgres and open a Postgres session
sudo -i -u postgres
psql
 
In the pg_hba.conf, change the host to 'trust' to get operational
 
 
# Database administrative login by Unix domain socket
local  all            postgres                                peer
# TYPE  DATABASE        USER            ADDRESS                METHOD
# "local" is for Unix domain socket connections only
local  all            all                                    peer
# IPv4 local connections:
host    all            all            127.0.0.1/32            trust
 
In the postgresql.conf, change 'listen_addresses' to get operational
listen_addresses = '*'
 


Install PHP 7.0
Install PHP 7.0

Revision as of 12:26, 15 June 2016

Install Apache

sudo apt-get install apache2

Install Postgresql

sudo apt-get install postgresql postgresql-contrib

The contrib is used with PGadmin III. The install creates a system user account: postgres

Change O/S user to postgres and open a Postgres session

sudo -i -u postgres
psql

In the pg_hba.conf, change the host to 'trust' to get operational


# Database administrative login by Unix domain socket
local   all             postgres                                peer

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust

In the postgresql.conf, change 'listen_addresses' to get operational

listen_addresses = '*'


Install PHP 7.0

sudo apt-get install php
sudo apt-get install php7.0-pgsql