aster.cloud aster.cloud
  • /
  • Platforms
    • Public Cloud
    • On-Premise
    • Hybrid Cloud
    • Data
  • Architecture
    • Design
    • Solutions
    • Enterprise
  • Engineering
    • Automation
    • Software Engineering
    • Project Management
    • DevOps
  • Programming
    • Learning
  • Tools
  • About
  • /
  • Platforms
    • Public Cloud
    • On-Premise
    • Hybrid Cloud
    • Data
  • Architecture
    • Design
    • Solutions
    • Enterprise
  • Engineering
    • Automation
    • Software Engineering
    • Project Management
    • DevOps
  • Programming
    • Learning
  • Tools
  • About
aster.cloud aster.cloud
  • /
  • Platforms
    • Public Cloud
    • On-Premise
    • Hybrid Cloud
    • Data
  • Architecture
    • Design
    • Solutions
    • Enterprise
  • Engineering
    • Automation
    • Software Engineering
    • Project Management
    • DevOps
  • Programming
    • Learning
  • Tools
  • About
  • Data
  • Programming

How To Install And Configure PostgreSQL In Ubuntu

  • root
  • July 16, 2019
  • 1 minute read

Overview

This guide contains instructions on how to install and do basic configuration of a PostgreSQL  database.

 


Partner with aster.cloud
for your next big idea.
Let us know here.



From our partners:

CITI.IO :: Business. Institutions. Society. Global Political Economy.
CYBERPOGO.COM :: For the Arts, Sciences, and Technology.
DADAHACKS.COM :: Parenting For The Rest Of Us.
ZEDISTA.COM :: Entertainment. Sports. Culture. Escape.
TAKUMAKU.COM :: For The Hearth And Home.
ASTER.CLOUD :: From The Cloud And Beyond.
LIWAIWAI.COM :: Intelligence, Inside and Outside.
GLOBALCLOUDPLATFORMS.COM :: For The World's Computing Needs.
FIREGULAMAN.COM :: For The Fire In The Belly Of The Coder.
ASTERCASTER.COM :: Supra Astra. Beyond The Stars.
BARTDAY.COM :: Prosperity For Everyone.

Prerequisites

  • Operating System : Ubuntu 18.04
  • Access to a Terminal or Shell Console

 

Install

01: Open a terminal window

 

02: Update the package repository list


$ sudo apt update

 

03: Install PostgreSQL via APT package manager. Enter y when asked to confirm.


$ sudo apt install postgresql postgresql-contrib

 

04: Change to the postgres user account.


$ sudo -i -u postgres

 

05: Access the psql shell


$ psql

 

06: Verify that installed correctly by showing the built-in PostgreSQL system tables.


postgres=# SELECT * FROM pg_catalog.pg_tables;

 

Press q to exit from the listing of sql tables.

 

07: Exit from the psql session


# Exit from psql

postgres=# \q

# Exit from postgres user

postgres@ubuntu-bionic: ~$ exit

 

Accept database connection from anywhere

WARNING: Use only in development environment, this poses a security concern when applied in a production environment. 

01: Edit the postgre config located at

/etc/postgresql/<sql-version>/main/postgresql.conf

At the time of this writing the stable version of PostgreSQL is 10.

# FORMAT

$ sudo nano /etc/postgresql/<b>{sql-version}</b>/main/postgresql.conf

# SAMPLE

$ sudo nano /etc/postgresql/<b>10</b>/main/postgresql.conf


localhost
is the default value, which means it can only be accessed locally from the server. And not remotely.

 

02: Set to asterisk, *, to make it accessible anywhere, then save the changes.

 

03: Restart the PostgreSQL service to apply the changes in config.


$ sudo service postgresql restart

Read More  Canonical At HPE Discover 2022

For enquiries, product placements, sponsorships, and collaborations, connect with us at [email protected]. We'd love to hear from you!

Our humans need coffee too! Your support is highly appreciated, thank you!

root

Related Topics
  • Database
  • How To
  • Installation
  • PostgreSQL
  • RDB
  • Ubuntu
You May Also Like
Data center. Servers.
View Post
  • Data
  • Platforms
  • Software

Intel Granulate Optimizes Databricks Data Management Operations

  • November 27, 2023
View Post
  • Data
  • Technology

Intel Joins the MLCommons AI Safety Working Group

  • October 26, 2023
View Post
  • Data
  • Engineering
  • Technology

Canonical announces supported solution for Apache Spark® on Kubernetes

  • October 17, 2023
View Post
  • Data
  • Technology

Huawei Provides Reliable Networks For Safe, Efficient Jakarta–Bandung High-Speed Railway

  • October 9, 2023
View Post
  • Data
  • Technology

Huawei and Partners’s project ‘Techco practicing decision intelligence for sustainable growth’ Wins TM Forum Award

  • October 9, 2023
View Post
  • Data
  • Engineering
  • Platforms
  • Solutions

How ‘Anything Is Possible’ Automated Data Pipelines With BigQuery And Windsor.ai

  • September 27, 2023
View Post
  • Data
  • Multi-Cloud
  • Platforms

Microsoft And Oracle Expand Partnership To Deliver Oracle Database Services On Oracle Cloud Infrastructure In Microsoft Azure

  • September 14, 2023
View Post
  • Data
  • Learning

Resources to Take Your Charts From Bland to Beautiful

  • September 6, 2023

Stay Connected!
LATEST
  • 1
    Bard Gets Its Biggest Upgrade Yet With Gemini
    • December 6, 2023
  • Gemini 2
    Introducing Gemini: Our Largest And Most Capable AI Model
    • December 6, 2023
  • 3
    Kubernetes CRD Validation Using CEL
    • December 4, 2023
  • 4
    AI For Impact: How Google Cloud Is Bringing AI To Accelerate Climate Action
    • December 3, 2023
  • Birthday Cake 5
    How ChatGPT Altered Our World in Just One Year
    • November 30, 2023
  • OpenAI 6
    Sam Altman Returns As CEO, OpenAI Has A New Initial Board
    • November 30, 2023
  • Web 7
    Mastering the Art of Load Testing for Web Applications
    • November 29, 2023
  • 8
    The IBM Approach To Reliable Quantum Computing
    • November 28, 2023
  • 9
    IBM Collaborates with AWS to Launch a New Cloud Database Offering, Enabling Customers to Optimize Data Management for AI Workloads
    • November 27, 2023
  • Data center. Servers. 10
    Intel Granulate Optimizes Databricks Data Management Operations
    • November 27, 2023
about
Hello World!

We are aster.cloud. We’re created by programmers for programmers.

Our site aims to provide guides, programming tips, reviews, and interesting materials for tech people and those who want to learn in general.

We would like to hear from you.

If you have any feedback, enquiries, or sponsorship request, kindly reach out to us at:

[email protected]
Most Popular
  • Oracle | Microsoft 1
    Oracle Cloud Infrastructure Utilized by Microsoft for Bing Conversational Search
    • November 7, 2023
  • Riyadh Air and IBM 2
    Riyadh Air And IBM Sign Collaboration Agreement To Establish Technology Foundation Of The Digitally Led Airline
    • November 6, 2023
  • Ubuntu. Chiselled containers. 3
    Canonical Announces The General Availability Of Chiselled Ubuntu Containers
    • November 25, 2023
  • Ingrasys 4
    Ingrasys Unveils Next-Gen AI And Cooling Solutions At Supercomputing 2023
    • November 15, 2023
  • Cyber Monday Sale. Guzz. Ideals collection. 5
    Decode Workweek Style with guzz
    • November 23, 2023
  • /
  • Technology
  • Tools
  • About
  • Contact Us

Input your search keywords and press Enter.