Subject: Configure Postgres
Author: Linux
In response to: How to Install PostgreSQL on Ubuntu 16.04 LTS
Posted on: 09/04/2017 11:19:17 PM
Step 4) Configure Postgres to allow reomte access -- optional
-- adminstrator@ubuntu:~$ sudo nano /etc/postgresql/9.6/main/postgresql.conf
Change:
#listen_addresses = 'localhost'
to:
Step 5) Restart Postgres -- optional-- adminstrator@ubuntu:~$ sudo /etc/init.d/postgresql restart
>
> On 09/04/2017 11:17:48 PM
Linux wrote:
Step 1) Install Postgres key
-- adminstrator@ubuntu:~$ wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
Step 2) Add APT repository
-- adminstrator@ubuntu:~$ sudo sh -c 'echo deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main > /etc/apt/sources.list.d/postgresql.list'
Step 3) Install Postgres
-- adminstrator@ubuntu:~$ sudo apt-get update
-- adminstrator@ubuntu:~$ sudo apt-get install postgresql postgresql-contrib
References:
