Shulou(Shulou.com)06/01 Report--

Today, the editor will share with you the relevant knowledge points about how to install postgreSQL11 in CentOS7. The content is detailed and the logic is clear. I believe most people still know too much about this knowledge, so share this article for your reference. I hope you can get something after reading this article. Let's take a look.

PostgreSQL is a powerful open source object-relational database system that uses and extends the SQL language and combines many capabilities to securely store and extend the most complex data workloads.

1. Add PostgreSQL Yum repository sudo yum install https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-centos11-11-2.noarch.rpm2. Install PostgreSQL Server and client software package sudo yum-y install postgresql11-server postgresql113. Initialize the database and enable automatic startup # initialize sudo / usr/pgsql-11/bin/postgresql-11-setup initdb# boot sudo systemctl start postgresql-11# settings boot self-boot sudo systemctl enable postgresql-11# the following two configurations are about firewalls (I didn't use them) sudo firewall-cmd-- add-service=postgresql-- permanentsudo firewall-cmd-- reload4. Enable remote access to PostgreSQL (the purpose is to connect to your database through the public network If you have a public network ip) # my path is like vi / var/lib/pgsql/11/data/postgresql.conf# modify listen_addresses ='*'# my path is like this sudo vim / var/lib/pgsql/11/data/pg_hba.conf# modify host all all 127.0.0.1 trust# 32 md5# add host all all 0.0.0.0 trust# restart sudo systemctl restart postgresql-115. Set the password for the PostgreSQL administrator user (be sure to configure the username and password according to this format) sudo su-postgrespsql-c "alter user postgres with password '123456'"

It should be noted that if it is a CVM, you need to open the corresponding port. That's what I suffered, and it took me a long time.

These are all the contents of the article "how to install postgreSQL11 in CentOS7". Thank you for reading! I believe you will gain a lot after reading this article. The editor will update different knowledge for you every day. If you want to learn more knowledge, please pay attention to the industry information channel.

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.