PostgreSQL is a powerful, open-source database system known for its strength and ability to grow with your needs. It supports many data types and advanced features, such as complex queries and triggers. PostgreSQL is very flexible, letting you create your own data types and operators. It follows SQL standards closely and ensures data reliability with ACID transactions. With a large community, PostgreSQL keeps improving and offers plenty of help and tools for users.<\/p>\n\n\n\n
Mount Linux Media and Link Yum Repository either on Internet or locally.<\/strong><\/p>\n\n\n\n Stop Fire wall and disable SELinux Create Directory for Database Files Installing PostgreSQL RPM from mounted Linux Media Replace Database Directory Path in below PostgreSQL File Initialize PostgreSQL Database Connection : Specifies the TCP\/IP address(es) on which the server is to listen for connections from Client Applications (List IP Address for Allow) it only matches connection attempts made over TCP\/IP that do not use SSL (hostnossl database user address auth-method) Start and Enable PostgreSQL Services Change Password of Postgre User Create Database and User in PostgreSQL Check PostgreSQL Configuration Parameters Check Database Directory of PostgreSQL <\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":427,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[38],"tags":[46,45],"class_list":["post-416","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql","tag-postgresql","tag-postgresql-installation"],"_links":{"self":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/comments?post=416"}],"version-history":[{"count":6,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/416\/revisions"}],"predecessor-version":[{"id":593,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/416\/revisions\/593"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media\/427"}],"wp:attachment":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media?parent=416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/categories?post=416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/tags?post=416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/strong>service firewalld stop
setenforce 0
vi \/etc\/sysconfig\/selinux
SELINUX=enforcing<\/p>\n\n\n\n
<\/strong>mkdir -p \/u01\/data
chown -R postgres:postgres \/u01\/data
chmod 777 \/u01\/data<\/p>\n\n\n\n
<\/strong>sudo dnf install postgresql-server postgresql-contrib -y<\/p>\n\n\n\n
<\/strong>vi \/lib\/systemd\/system\/postgresql.service
Environment=PGDATA=\/u01\/data<\/p>\n\n\n\n
<\/strong>\/usr\/bin\/postgresql-setup –initdb<\/p>\n\n\n\n
<\/strong>vi \/u01\/data\/postgresql.conf
listen_addresses = ‘*’<\/p>\n\n\n\n
<\/strong>vi \/u01\/data\/pg_hba.conf
hostnossl all all 0.0.0.0\/0 trust<\/p>\n\n\n\n
<\/strong>systemctl start postgresql
systemctl enable postgresql<\/p>\n\n\n\n
<\/strong>sudo -i -u postgres
psql
\\password postgres
\\q<\/p>\n\n\n\n
<\/strong>psql
create database Inventory;
CREATE USER kamran WITH PASSWORD ‘kamran’;
GRANT ALL PRIVILEGES ON DATABASE inventory TO kamran;
\\q<\/p>\n\n\n\n
<\/strong>SHOW config_file;<\/p>\n\n\n\n
<\/strong>SHOW data_directory;
\\q<\/p>\n\n\n\n\n\n