PostgresSQL

PostgresSQL

Overview

Windows Server

Ubuntu

CentOS

Overview

PostgresSQL

Postgres is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. As a database server, its primary functions are to store data securely and return that data in response to requests from other software applications. It can handle workloads ranging from small single-machine applications to large Internet-facing applications (or for data warehousing) with many concurrent users; on macOS Server, PostgreSQL is the default database and it is also available for Microsoft Windows and Linux.

Windows Server

Ubuntu

Installation Steps Ubuntu 14.04 LTS

Version : “PostgreSQL 9.5.11″

Steps to access Postgres :

Switch to the postgres account on server by typing: sudo -i -u postgres

You can access a Postgres prompt by typing: psql

Ports:

SSH Port :22

TCP: 5432

Installation Steps for Ubuntu 16.04 LTS

Version : “PostgreSQL 9.5.11″

Steps to access Postgres :

Switch to the postgres account on server by typing: sudo -i -u postgres

You can access a Postgres prompt by typing: psql

Ports:

SSH Port :22

TCP: 5432

CentOS

Installation Steps for CentOS 7.4

Version : “PostgreSQL 9.2.23 “

Steps to access Postgres :

Switch to the postgres account on server by typing: sudo -i -u postgres