Ubuntu 14.04 Install PostgreSQL latest version

Source: Internet
Author: User
Tags postgresql postgresql packages

Official website: https://www.postgresql.org/download/linux/ubuntu/

--------------------------------------------------------------------------------------------------------------- -----

Another article, which is about the same:

http://tecadmin.net/install-postgresql-server-on-ubuntu/#

PostgreSQL is an open source object-relational database system. It is one of the leading database server used for production servers. PostgreSQL allows us to execute stored procedures in various programming languages, like C/C + +, Python, Java, Perl, Ruby a nd its own pl/pgsql, which are similar to Oracle PL/SQL

This article would help you to installing PostgreSQL database server on your Ubuntu systems.

Step 1:add PostgreSQL Apt Repository

PostgreSQL packages is also available in default Ubuntu repository, if I try to install PostgreSQL on Ubuntu 12.04 I only found PostgreSQL 9.1 is in default apt repository. So I request your to add PostgreSQL apt repository first in your system suggested on official PostgreSQL website using foll Owing command.

$ sudo sh-c ' echo ' deb http://apt.postgresql.org/pub/repos/apt/' Lsb_release-cs '-pgdg main ' >>/ETC/APT/SOURCES.L Ist.d/pgdg.list ' $ wget-q Https://www.postgresql.org/media/keys/ACCC4CF8.asc-O-| sudo apt-key add-
Step 2:install PostgreSQL

Now as we had added PostgreSQL official repository in our system, first we need to update repository list. After the install Latest PostgreSQL Server in our Ubuntu system using following commands.

$ sudo apt-get update$ sudo apt-get install PostgreSQL postgresql-contrib
Step 3:connect to PostgreSQL

After installing PostgreSQL database server, by default it creates a user ' postgres ' with role ' postgres '. It also creates a system account with same name ' Postgres '. So-connect to Postgres server, login to your system as user Postgres and connect database.

$ sudo su-postgres$ psql

Now is logged in to PostgreSQL database server. To check the login info use following command from database command prompt.

postgres-# \conninfo

To disconnect from PostgreSQL database command prompt just type below command and press ENTER. It'll return you to Ubuntu command prompt.

postgres-# \q

Your PostgreSQL installation has been completed successfully. Let's move to phppgadmin installation of Ubuntu systems.

Ubuntu 14.04 Install PostgreSQL latest version

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.