PgAdmin 4 is available in the same PostgreSQL 11 yum repository.īut first we are installing EPEL (Extra Packages for Enterprise Linux) yum repository, because pgAdmin 4 requires some packages that are available in EPEL yum ~]# yum install -y epel-release To ease the process of Database Administration of PostgreSQL, we are installing a popular SQL web interface i.e. Installing pgAdmin 4 Web Interface on CentOS 7: Our PostgreSQL service is configured for remote access. Restart PostgreSQL service to apply ~]# systemctl restart rviceĪllow PostgreSQL service in Linux ~]# firewall-cmd -permanent ~]# firewall-cmd -reload However, if required we can configure it for remote access from other computers in our network.Įdit PostgreSQL configuration ~]# vi /var/lib/pgsql/11/data/nfįind and set following directive in this file.Īllow network clients to access PostgreSQL service in pg_hba.conf ~]# echo "host all all 192.168.116.0/24 md5" > /var/lib/pgsql/11/data/pg_hba.conf PostgreSQL 11 server has been installed on our CentOS 7 server.Ĭonfiguring PostgreSQL Remote Access on CentOS 7:īy default, PostgreSQL service runs locally on port 5432/tcp.
Postgres=# ALTER USER postgres WITH PASSWORD '123' Initialize PostgreSQL database instance as ~]# /usr/pgsql-11/bin/postgresql-11-setup initdbĮnable and start PostgreSQL ~]# systemctl enable rviceĬreated symlink from /etc/systemd/system//rvice to ~]# systemctl start rviceĬonnect as postgres user and set admin ~]# su - postgres Userid : "PostgreSQL RPM Building Project "įingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8 Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG Public key for 86_64.rpm is not installed Warning: /var/cache/yum/x86_64/7/pgdg11/packages/86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY Install 2 Packages (+1 Dependent package) > Package postgresql11-libs.x86_64 0:11.4-1PGDG.rhel7 will be installed > Package postgresql11-server.x86_64 0:11.4-1PGDG.rhel7 will be installed > Processing Dependency: libpq.so.5()(64bit) for package: 86_64 > Package postgresql11.x86_64 0:11.4-1PGDG.rhel7 will be installed Install PostgreSQL 11 client and server packages using yum ~]# yum install -y postgresql11 postgresql11-server
Loading mirror speeds from cached hostfile Verifying : 1/1ĭisable old version PostgreSQL yum ~]# yum-config-manager -disable pgdg10 pgdg94 pgdg95 pgdg96īuild cache for yum ~]# yum makecache fast Pgdg-redhat-repo noarch 42.0-4 /pgdg-redhat-repo-latest.noarch 6.8 k > Package pgdg-redhat-repo.noarch 0:42.0-4 will be installed Marking /var/tmp/yum-root-zy9vpg/ to be installed Install PostgreSQL yum repository using following ~]# yum install -y
Yum repositories for various Linux distros can be obtained from PostgreSQL official download page. Therefore, we have to add PostgreSQL yum repository in our CentOS 7 server and then we will be able to install PostgreSQL 11. In CentOS 7.6, PostgreSQL 9.2 is available in standard yum repositories.īut we are required to install latest version of PostgreSQL i.e. We have configured a CentOS 7 virtual machine with following specifications.Ĭonnect with using ssh as root user.
PgAdmin is the most popular open source and feature enrich web interface for administration of PostgreSQL database servers. It is the default database for MacOS server but also available for other platforms.
PostgreSQL is developed by the PostgreSQL Global Development Group.
PostgreSQL (or Postgres) is a free and open-source, relational database management system (RDBMS) emphazing on extensibility and technical standards compliance.