What is PostgreSQL? PostgreSQL is a powerful, open source object-relational database system ( ORDBMS ). Unlike other relational database systems, PostgreSQL (Postgres) allows users to create unique operators, complex data…
postgres
-
-
DatabasesLinuxUbuntu
How to install pgAdmin 4 in desktop mode on Ubuntu 16.04 LTS
by Lotfi Waderni March 21, 2017PgAdmin 4 is a rewrite of the popular pgAdmin3 management tool for the PostgreSQL database. PgAdmin is the leading graphical Open Source management, development and administration tool for PostgreSQL. In…
-
DatabasesUbuntu
How To Change PostgreSQL Data Directory Location on Ubuntu 16.04
by Lotfi Waderni February 3, 2017Let’s suppose that the database grows frequently and need more space, the best solution is to relocate the PostgreSQL data directory to a new location. In this article, we will…
-
DatabasesLinuxUbuntu
How To Install PostgreSQL 9.6 On Ubuntu Xenial 16.04 LTS
by Lotfi Waderni January 29, 2017PostgreSQL is a powerful object-relational database management system, provided under a flexible BSD-style license. PostgreSQL contains many advanced features, is very fast and standards compliant. PostgreSQL has bindings for many…
-
Centos/RedhatDatabasesLinux
How To Install PostgreSQL 9.6 on CentOS 7 / RHEL 7
by Lotfi Waderni January 17, 2017Step 1: Add the PostgreSQL 9.6 Repository # sudo yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm -y Step 2: Install PostgreSQL 9.6 – To install PostgreSQL 9.6 just run the below command: # sudo…