Shulou(Shulou.com)05/31 Report--

This article mainly explains "CentOS7 how to install PostgreSQL11", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "CentOS7 how to install PostgreSQL11" bar!

Environment

Aliyun centos 7.3.1611

Postgresql 11

Postgresql

Postgresql is an object-relational database management system (ordbms) based on the object-relational database management system (ordbms) developed by the Department of computer Science at the University of California, Berkeley and now renamed postgresql. Postgresql supports most sql standards and provides many other modern features: complex queries, foreign keys, triggers, views, transaction integrity, mvcc. Similarly, postgresql can be extended in many ways, for example, by adding new data types, functions, operators, aggregation functions, and indexes. Free use, modification, and distribution of postgresql, whether for private use, commercial use, or academic research.

Postgresql has built in json data types since version 9.3, while jsonb has been supported since 9.4, indicating that postgresql is actually a combination of a relational database and an nosql database. Although postgresql is still located in relational databases, the nosql performance of recent updates to postgresql has even surpassed that of mongodb.

Postgresql installation

Postgresql 11 is installed here as rpm

# download rpm package yum install https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-redhat11-11-2.noarch.rpm-y # install yum-y install postgresql11 postgresql11-server postgresql11-libs# initialization database / usr/pgsql-11/bin/postgresql-11-setup initdb# settings boot postgresql and startup service systemctl enable postgresql-11systemctl start postgresql-11systemctl status postgresql-11## see The active output from the console is followed by the word running indicating that the startup is complete.

Postgresql connection

# Log in to the database, switch the account postgressu-postgrespsql# navicat to connect to postgresql# here, modify the configuration file postgresql.conffind /-name postgresql.confvi / var/lib/pgsql/11/data/postgresql.conf#, find listen_address, unlock the comments and change the value of localhost in quotation marks to * listen_address= "*" # Save and exit Restart postgresql service systemctl restart postgresql-11# Aliyun Security Group Rule configuration-> quickly add Security Group rules-> check postgresql and add # in navicat connection, if you do not change localhost to *, navicat connection will prompt an error "connection refuse" # I have modified the password of postgres user here. The steps are as follows: # # enter psqlsu-postgrespsql## to modify password alter user postgres password 'password'

Connection successful!

Thank you for reading, the above is the content of "how to install PostgreSQL11 in CentOS7". After the study of this article, I believe you have a deeper understanding of how to install PostgreSQL11 in CentOS7, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.