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 types, aggregate functions,…
postgresql replication
-
-
Centos/RedhatDatabasesLinux
How To Install PostgreSQL 10 on CentOS 7 / RHEL 7
by Lotfi Waderni October 31, 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…
-
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…