{"id":2850,"date":"2020-12-22T18:58:10","date_gmt":"2020-12-22T18:58:10","guid":{"rendered":"https:\/\/linuxways.net\/?p=2850"},"modified":"2020-12-22T19:04:28","modified_gmt":"2020-12-22T19:04:28","slug":"how-to-install-postgresql-in-centos-8","status":"publish","type":"post","link":"https:\/\/linuxways.net\/de\/centos\/how-to-install-postgresql-in-centos-8\/","title":{"rendered":"How to Install PostgreSQL in CentOS 8"},"content":{"rendered":"

PostgreSQL, which is popular with a name as Postgres, is an open-source and freely available relational database management system. This type of database server more emphasis on SQL compliance and extensibility. In this article, we will elaborate on the installation of PostgreSQL on CentOS 8 Linux distribution.<\/p>\n

Prerequisites<\/strong><\/h2>\n

You should be login as the root user or you must have privileges to run the \u2018sudo\u2019 command on your system.<\/p>\n

Installation of PostgreSQL databases on CentOS 8<\/strong><\/h2>\n

First, you will open the command line application \u2018Terminal\u2019 by clicking on the terminal icon from the left sidebar of your desktop. Type the below-mentioned command to log in on your terminal as the root user:<\/p>\n

$ su<\/pre>\n
Enter the root account password.<\/p>\n
<\/p>\n
Now, you can run all the administrative commands for PostgreSQL installation.<\/p>\n
To complete the installation of PostgreSQL on CentOS 8, you will implement the following steps:<\/p>\n
Step 1: Update system cache<\/strong><\/h3>\n
It is a recommended and quite an easy step that you should update the repository cache of your system repository or packages by using the following command:<\/p>\n
# dnf makecache<\/pre>\n
<\/p>\n
Step 2: Install PostgreSQL<\/strong><\/h3>\n
All package has been updated. Now, execute the below-given command to install the PostgreSQL server on your system:<\/p>\n
# dnf install postgresql postgresql-server<\/pre>\n
<\/p>\n
During the installation, you need to press \u2018y\u2019 and then hit the \u2018Enter\u2019 key to confirm the installation of PostgreSQL.<\/p>\n
<\/p>\n
The complete status will display on the terminal that represents the installation of PostgreSQL has been completed.<\/p>\n
Step 3: Check installed version of PostgreSQL<\/strong><\/h3>\n
Once the installation of PostgreSQL is complete, to verify the working of PostgreSQL databases run the below-mentioned command:<\/p>\n
# postgres --version<\/pre>\n
<\/p>\n
As you can see in the above screenshot the Postgres 10.14 is installed on this system.<\/p>\n
Step 4: Initialize the PostgreSQL database<\/strong><\/h3>\n
To initialize the PostgreSQL database server directory, type the following command on the terminal:<\/p>\n
# postgresql-setup --initdb<\/pre>\n
<\/p>\n
Step 5: Enable and Start PostgreSQL services<\/strong><\/h3>\n
You can enable the services of PostgreSQL by running the following set of commands:<\/p>\n
# systemctl enable postgresql<\/pre>\n
<\/p>\n
To know the services running status, use the below-mentioned commands:<\/p>\n
# systemctl start postgresql<\/pre>\n
# systemctl status postgresql<\/pre>\n
<\/p>\n
<\/p>\n
Remove PostgreSQL server<\/strong><\/h2>\n
If you don\u2019t want to use the PostgreSQL database server on your system then, by using the following command you can remove it:<\/p>\n
# dnf remove postgresql postgresql-server<\/pre>\n
<\/p>\n
Creating a new PostgreSQL database<\/strong><\/h2>\n
Login as root on your PostgreSQL database server as follows:<\/p>\n
<\/p>\n
Now, we have created a new PostgreSQL database with the name \u2018samreenadb\u2019 by using the following command:<\/p>\n
$ createdb samreenadb<\/pre>\n
Now, access the created database \u2018samreenadb\u2019 by using the following command:<\/p>\n
$ psql samreenadb<\/pre>\n
<\/p>\n
To test the working of the above-mentioned database execute the following SQL query:<\/p>\n
SELECT CURRENT_DATE;<\/pre>\n
<\/p>\n
As you can see in the above-displayed image, the query is working on this database.<\/p>\n
Create Tables in PostgreSQL Database<\/strong><\/h2>\n
Here, we can create tables and assigned privileges on this database by pasting the following code in your current database shell which you can also see in the below-displayed screenshot:<\/p>\n
CREATE TABLE users (\n\nid INT NOT NULL,\n\nname VARCHAR(16) NOT NULL,\n\npin VARCHAR(4) NOT NULL\n\n);<\/pre>\n
<\/p>\n
As you can see the table is created in the above screenshot with the name \u2018users\u2019.<\/p>\n
To list all tables or relations of your database run the below-given command:<\/p>\n
# \\d<\/pre>\n
<\/p>\n
To exit from the database type the following command:<\/p>\n
# \\q<\/pre>\n
<\/p>\n
Conclusion<\/strong><\/h2>\n
So, we have demonstrated in this article how you install and remove the PostgreSQL server and create a database in PostgreSQL on CentOS 8. We have also shown how you can add tables in the database by using the SQL query. I hope this article would be helpful and knowledgeable for you.<\/p>","protected":false},"excerpt":{"rendered":"
PostgreSQL, which is popular with a name as Postgres, is an open-source and freely available relational database management system. This type of database server more emphasis on SQL…<\/p>","protected":false},"author":2,"featured_media":2872,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[93,43],"class_list":["post-2850","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-centos","tag-centos-8","tag-postgresql"],"_links":{"self":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/2850","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/comments?post=2850"}],"version-history":[{"count":0,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/2850\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media\/2872"}],"wp:attachment":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media?parent=2850"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/categories?post=2850"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/tags?post=2850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}