{"id":3800,"date":"2018-10-15T11:12:20","date_gmt":"2018-10-15T11:12:20","guid":{"rendered":"https:\/\/dbtut.com\/?p=3800"},"modified":"2019-11-07T07:13:35","modified_gmt":"2019-11-07T07:13:35","slug":"how-to-install-postgresql-on-centos-redhat","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/10\/15\/how-to-install-postgresql-on-centos-redhat\/","title":{"rendered":"How To Install PostgreSQL On centos\/redhat"},"content":{"rendered":"\n
First we go to https:\/\/yum.postgresql.org and into PostgreSQL where we will download the repo. Since we will install PostgreSQL 10 in our example, we will click on 10.<\/p>\n
<\/p>\n
Then right click on \u201cCentos 7 \u2013 x86_64\u201d in the screen below and we click copy link location.<\/p>\n
<\/p>\n
We connect to our Centos server via ssh and become root using the below command.<\/p>\n
su root<\/pre>\n
Then write yum install and right click and paste the link that we copied after leaving a space. Run the command to download the repo to the server.<\/p>\n
Go to the root directory with the command below.(or the directory you want to create postgresql directories)<\/p>\n
cd \/<\/pre>\n
Here, you need to define two separate directories for the data and log files. Since this is an example, I will create two files in a single directory.<\/p>\n
In our example, we create two folders in the directory named Postgres under the Home directory with the following commands.<\/p>\n
mkdir pg_data\nmkdir pg_xlog<\/pre>\n
Then we use the command cd ..<\/code> to go back to the parent directory and assign the postgres user as the owner for each file and folder created under the postgres directory and the postgres directory with the following command.<\/p>\n
chown -R postgres:postgres \/postgres<\/pre>\n
We then specify these folders with the -D and -X parameters when performing initdb.<\/p>\n
pg_data (data directory -D)<\/p>\n
pg_xlog (wal directory X)<\/p>\n
Use the following command to configure authorizations in the root directory.<\/p>\n
Use the command below to create public and private keys.(ssh connectivity<\/strong>), We’ll be able to connect to the other server without a password between two postgresql server by copying these keys to the standby server. Run this command and press enter a few times.<\/p>\n
ssh-keygen -t rsa<\/pre>\n
Then copy the public key to the standby server with the command below.<\/p>\n
192.168.1.29 is the IP of the standby server.<\/p>\n
ssh-copy-id 192.168.1.29<\/pre>\n
It will ask the password of postgres user. If you enter the password, you will get an error. Because the password was not created on the standby server.<\/p>\n
Once you have created the password in the standby server, you should run the command again.<\/p>\n
Then we will test to see if we can connect without password between two postgresql.<\/p>\n
ssh postgres@192.168.1.29<\/pre>\n
If the connection is not established, turn off the firewall with the following command on the standby server.\u00a0<\/p>\n
Stop Firewalld<\/h3>\n
service firewalld stop<\/pre>\n
In addition, you need to disable selinux.<\/p>\n
Disable selinux<\/h3>\n
When we are root, we open the file with the command below and change enforcing to disable.<\/p>\n
vim \/etc\/selinux\/config<\/pre>\n
Start PostgreSQL with pg_ctl<\/h3>\n
Then, start the postgresql with pg_ctl with the help of the following command.<\/p>\n
I recommend that you start service with the systemctl command while you are the root user. First, we fix the path of the PostgreSQL service. To do this, open the service using the command below.<\/p>\n
vi \/lib\/systemd\/system\/postgresql-10.service<\/pre>\n
Find the Environment line and change it as follows.<\/p>\n
Environment=PGDATA=\/postgres\/pg_data\/<\/pre>\n
Enable, Reload and Start PostgreSQL Service<\/h3>\n
Then enable and start the service with the command below. If you do not enable the postgres service, it does not start automatically after server restart.<\/p>\n
![\"\"](\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/Ads\u0131z-7.png\")
<\/p>\n![\"\"](\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/Ads\u0131z-8.png\")
<\/p>\n