•  Home
  •  Dashboard
  •  Services
    • Dedicated Servers
    • Colocation
    • Private Cloud
    • DDoS Protection
    • IP Transit
    • Backup
    • CDN
    • GGA
  •  Solutions
    • Ecommerce
    • Security
    • Gaming
    • Hosting
    • Management
    • Finance
    • System Integrator
  •  Support
    • Knowledgebase
    • Community
    • Open Ticket
  •  Company
    • About Us
    • Contact Us
    • Network
    • Data Centers
    • Looking Glass
    • Affiliates
    • Reseller
    • Blog
  • Services
    • Dedicated Servers
    • Colocation
    • Private Cloud
    • DDos Protection
    • IP Transit
    • CDN
    • GGA
    • Backup
  • Solutions
    • Ecommerce
    • Security
    • Gaming
    • Hosting
    • Management
    • Finance
    • System Integrator
  • Dashboard

How to install postgresql on Ubuntu?

  • Home
  • Client
  • Qa Forum
  • How to install postgresql on Ubuntu?

Posted By: Ruijin | 1 Replies | Last Reply On: May 26, 2017 05:50:25

Can someone direct me to some link or provide steps that work when it comes to installing postgresql on Ubuntu? 

Psychz - Chetan

Votes: 0Posted On: May 26, 2017 05:50:25
 

The primary functionality of PostgreSQL is secure storage for data and returning data on requests from other software applications. It is available on Microsoft Windows as well as Linux, whereas, it is the default database system on MacOS. It user base can range from single machines to data warehousing with a large number of concurrent users. PostgresSQL is also abbreviated as "Postgres". PostgreSQL has advanced features such as updatable and materialized views, triggers, foreign keys among others. It also supports functions and stored procedures. Here are the steps that will help you to install PostgreSQL on Ubuntu operating system.

 

Prerequisites

1. Ubuntu Operating system - Ubuntu 14.04 in this case.

 

Installing PostgreSQL on Ubuntu

We use the "apt" command which is part of the Advanced Packaging Tool used to install or remove packages from the operating system. It is also better to update the package repository before installing the package to install the latest and updated version of the software. Since PostgreSQL is already a part of the APT package you just have to install the package. You can also install a "contrib" package along with PostgreSQL package if you want additional functionality and features.

Please run the following command to install PostgreSQL.

 

1. sudo apt-get update
2. sudo apt-get install postgresql postgresql-contrib

 

Here is a sample output for better understanding.

 

Related topics

  • Top SQL Databases
  • Ubuntu vs Mint
  • In Comparison: Ubuntu VS Linux Mint
  • How to install cPanel?
  • Ubuntu DDoS Protection
  • Enable SSH Ubuntu
  • Debian vs Ubuntu Server
  • Ubuntu remove mysql
  • Most Common Linux Distros
  • Best Open-Source Software For Linux Users
  • Installing IPMI Tool
  • Top Hosting Control Panels For Linux
  • Quagga Routing - Install, Configure and setup BGP
  • How To Install Git On Centos 7
  • Operating System Installation through client area
Hosting Services
  • Dedicated Hosting
  • Colocation Hosting
  • Backup
  • IP Transit
  • DDoS Mitigation
Support
  • Portal Login
  • Knowledgebase
  • Community
Company
  • About Us
  • Contact Us
  • Network
  • Data Centers
  • Looking Glass
  • Affiliates
  • Reseller
  • Blog
Policies
  • Privacy Policy
  • Acceptable Usage Policy
  • Terms and Conditions
  • Service Level Agreement
Company
  • Psychz Networks,
    A Profuse Solutions Company
    611 Wilshire Blvd #300
    Los Angeles,California 90017
    USA
  • US/Canada: 800-933-1517
  • International: 626-549-2801
Subscribe to Our Mailing List
* indicates required
Copyright © 2018 Psychz Networks, A Profuse Solutions Inc Company