{"id":866,"date":"2023-01-11T15:28:24","date_gmt":"2023-01-11T15:28:24","guid":{"rendered":"https:\/\/blog.ngocha.biz\/?p=866"},"modified":"2023-01-11T15:28:24","modified_gmt":"2023-01-11T15:28:24","slug":"install-postgresql-redhat-linux","status":"publish","type":"post","link":"https:\/\/blog.ngocha.biz\/?p=866","title":{"rendered":"How to Install & Configure PostgreSQL on Redhat Linux"},"content":{"rendered":"

If you want to install PostgreSQL on Redhat Linux, this guide is for you. It covers installation, configuration, and enabling remote connection.<\/p>\n

Install PostgreSQL on Redhat Linux<\/h2>\n

Follow the steps given below to install the latest version of PostgreSQL on RedHat Linux<\/p>\n

Step 1:<\/strong> Add the PostgreSQL Yum Repo<\/p>\n

Execute the following command to add the PostgreSQL yum repo.<\/p>\n

sudo yum install -y https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-7-x86_64\/pgdg-redhat-repo-latest.noarch.rpm<\/code><\/pre>\n
Step 2:<\/strong> Install the latest version of the PostgreSQL Server<\/p>\n
The latest version at the time of writing this guide is PostgreSQL 15. You can check the latest version available for Rehat on this page<\/a>.<\/p>\n
sudo yum install -y postgresql15-server<\/code><\/pre>\n
Step 3:<\/strong> Initialize the Database and Enable Automatic Start<\/p>\n
Execute the following commands to initialize the PostgreSQL database and add services to the server startup.<\/p>\n
sudo \/usr\/pgsql-15\/bin\/postgresql-15-setup initdb\nsudo systemctl enable postgresql-15\nsudo systemctl start postgresql-15<\/code><\/pre>\n
Enable PostgreSQL Remote Connection<\/h2>\n
By default the remote PostgreSQL connection is disabled. However, you can connect to the database locally. If you try to connect from a remote machine you will get an error like the following.<\/p>\n
psql: error: connection to server at \"34.221.35.108\", port 5432 failed: Connection refused\n\tIs the server running on that host and accepting TCP\/IP connections?<\/code><\/pre>\n
First login to the database using the following command.<\/p>\n
sudo -u postgres psql<\/code><\/pre>\n
Set the password for the Postgres user so that we can use it to log in remotely. Replace myPassword<\/code> with the required password.<\/p>\n
ALTER USER postgres PASSWORD 'myPassword';<\/code><\/pre>\n
To enable PostgreSQL remote connection on Redhat, you need to open the following file.<\/p>\n
sudo vi \/var\/lib\/pgsql\/15\/data\/postgresql.conf<\/code><\/pre>\n
Under CONNECTIONS AND AUTHENTICATION<\/code> section you will find the following commented parameter.<\/p>\n
#listen_addresses = 'localhost' <\/code><\/pre>\n
Replace it with the following and save the file. With this configuration, we are enabling PostgreSQL server connections to accept connections from all IP addresses.<\/p>\n
listen_addresses = '*' <\/code><\/pre>\n
\"PostgreSQL<\/figure>\n
To apply the change, restart the PostgreSQL service using the following command. If you are using any version other than 15, replace 15 with the relevant version number in the command.<\/p>\n
sudo systemctl restart postgresql-15<\/code><\/pre>\n
We have allowed connections on all interfaces. However, If you try to connect to the PostgreSQL RedHat server from a remote machine, you will get the following error because you need to enable client connections to all the Databases and users.<\/p>\n
psql: error: connection to server at \"34.221.35.108\", port 5432 failed: FATAL:  no pg_hba.conf entry for host \"49.205.132.96\", user \"postgres\", database \"postgres\", no encryption<\/code><\/pre>\n
To allow client connections to all databases, you need to edit the pg_hba.conf<\/strong> file.<\/p>\n
Open pg_hba.conf<\/strong> file.<\/p>\n
sudo vi \/var\/lib\/pgsql\/15\/data\/pg_hba.conf <\/code><\/pre>\n
Add the following line to the end of the file<\/strong>.<\/p>\n
host    all          all            0.0.0.0\/0  md5<\/code><\/pre>\n
\"\"<\/figure>\n
Restart the PostgreSQL server to apply changes.<\/p>\n
sudo systemctl restart postgresql-15<\/code><\/pre>\n
Now, validate the remote connection by connecting to the PostgreSQL server using the following command. Replace IP with your server IP.<\/p>\n
psql -h 34.221.35.108 -U postgres<\/code><\/pre>\n
When prompted for the password, use the password you set using the ALTER command.<\/p>\n
If you don’t have a password set for the Postgres user, you will get the following error.<\/p>\n
Password for user postgres:\npsql: error: connection to server at \"34.221.35.108\", port 5432 failed: FATAL:  password authentication failed for user \"postgres\"<\/code><\/pre>\n
Important PostgreSQL Server Configurations on Redhat<\/h2>\n
The following table contains important PostgreSQL configurations on the Redhat server. Replace 15 with the version of PostgreSQL you are using.<\/p>\n
<\/p>\n\n\n\n\n\n\n\n\n\n
Config<\/th>\nDetails<\/th>\n<\/tr>\n<\/thead>\n
PostgreSQL default port<\/td>\n5432<\/td>\n<\/tr>\n
Default user<\/td>\npostgres<\/td>\n<\/tr>\n
Config files location (postgresql.conf & pg_hba.conf<\/code> )<\/td>\n\/var\/lib\/pgsql\/15\/data\/pg_hba.conf 
\/var\/lib\/pgsql\/15\/data\/postgresql.conf <\/td>\n<\/tr>\n
Default database<\/td>\npostgres<\/td>\n<\/tr>\n
Default data directory<\/td>\n\/var\/lib\/pgsql\/15\/data<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/p>\n
Conclusion<\/h2>\n
As a DevOps engineer, it is essential to know the basic configurations involved in a Database. in this guide we looked at the steps to install PostgreSQL on a Redhat server.<\/p>\n
For the Ubuntu server, checkout the PostgreSQL installation on Ubuntu<\/a>.<\/p>\n
For the Amazon Linux server, Checkout the PostgreSQL installation on Amazon Linux<\/a><\/p>\n
Also, if you are using Kubernetes<\/a>, check out the guide on setting up PostgreSQL statefulset on Kubernetes<\/a><\/p>\n
If you are starting your DevOps engineer journey, look at my comprehensive guide to becoming a DevOps engineer<\/a>.<\/p>\n
\n
Ngu\u1ed3n:<\/strong> How to Install & Configure PostgreSQL on Redhat Linux \u2014 DevOpsCube<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Source: https:\/\/devopscube.com\/install-postgresql-redhat-linux\/<\/p>\n","protected":false},"author":1,"featured_media":867,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-866","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-devops"],"_links":{"self":[{"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=\/wp\/v2\/posts\/866","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=866"}],"version-history":[{"count":0,"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=\/wp\/v2\/posts\/866\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=\/wp\/v2\/media\/867"}],"wp:attachment":[{"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=866"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}