PostgreSQL or Postgres is an open-source general-purpose object-relational database management system with many advanced features that allows you to build fault-tolerant environments or complex applications. In this guide, we will…
postgresql
-
-
Centos/RedhatDatabasesLinux
How to Install and Use PostgreSQL on CentOS 8
by Lotfi Waderni May 2, 2020PostgreSQL is a powerful, open source object-relational database system ( ORDBMS ). Unlike other relational database systems, PostgreSQL allows users to create unique operators, complex data types, aggregate functions, data…
-
Centos/RedhatDatabasesLinux
How To install PostgreSQL 11 on CentOS 7 / RHEL 7
by Lotfi Waderni January 9, 2019What 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…
-
DatabasesLinuxUbuntu
How To Install PostgreSQL 11 on Ubuntu 18.04 LTS / 16.04 LTS
by Lotfi Waderni January 7, 2019What 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…
-
DatabasesLinux
How to Setup a Logical Replication on PostgreSQL 10
by Lotfi Waderni November 14, 2017PostgreSQL is a powerful, open source object-relational database system ( ORDBMS ). Unlike other relational database systems, PostgreSQL allows users to create unique operators, complex data types, aggregate functions, data…
-
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…
-
DatabasesLinux
How To Enable Network Remote Access To PostgreSQL Database Server
by Lotfi Waderni February 4, 2017By default, PostgreSQL Server allow access to clients localy using Unix sockets. Here, we’ll show you how to enable the network remote access to PostgreSQL Database Server. If you did…
-
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…
- 1
- 2