Ubuntu: How do I install PostgreSQL 9.6 on any Ubuntu version?



Question:

How do I install PostgreSQL 9.6 on any Ubuntu version since it doesn't come by default with the most recent version?

Ubuntu Xenial (16.04) comes with PostgreSQL 9.5 from the default repositories.


Solution:1

For the following Ubuntu versions, you can install with the given commands, as per the official PostgreSQL Apt Repository.

Ubuntu 17.04 - 17.10

Version 9.6 comes with the distribution.

sudo apt-get install postgresql-9.6  

Ubuntu 12.04, 14.04, 16.04

sudo add-apt-repository "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -sc)-pgdg main"  wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -  sudo apt-get update  sudo apt-get install postgresql-9.6  


Solution:2

Follow below steps:

Reference is taken from this blog.

You need to add the latest PostgreSQL repository for the latest version.

sudo add-apt-repository "deb https://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main"  

Update and Install PostgreSQL 9.6:

sudo apt-get update  sudo apt-get install postgresql-9.6  

Default postgres super user and postgres database is created. You need to set a password for the postgres super user.

ubuntu@:~$ sudo passwd postgres  Enter new UNIX password:****  Retype new UNIX password:****  passwd: password updated successfully  

If service is not started, you can start the PostgreSQL service.

sudo service postgresql start  

Connect PostgreSQL server using postgres user:

ubuntu@:~$ su postgres  Password:****  

Create a sample database:

createdb database_name  

Connect to that database:

psql -d database_name  


Solution:3

I followed this Github gist - I am running ubuntu xenial inside vagrant and wanted to upgrade existing postresql official repository vesion 9.5 to 9.6 so that I can use PostGIS extension which is served best by version 9.6 (officially mentioned in their site) Hope this helps someone.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »