Ubuntu 16.04 LAPP Setup: Difference between revisions
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