https://www.postgresql.org/download/linux/redhat/
1.2 下载postgresql9.5的repo# yum install https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-7-x86_64/pgdg-redhat95-9.5-3.noarch.rpm
# ll /etc/yum.repos.d/
-rw-r--r-- 1 root root 482 Jan 5 2016 pgdg-95-redhat.repo# yum install postgresql95
# yum install postgresql95-server
# systemctl enable postgresql-9.5
# systemctl start postgresql-9.5
# systemctl status postgresql-9.5.service
● postgresql-9.5.service - Postgresql 9.5 database server
Loaded: loaded (/usr/lib/systemd/system/postgresql-9.5.service; enabled; vendor preset: Disabled)
Active: active (running) since Wed 2018-04-18 07:40:03 EDT; 52s ago
*****************
# /usr/pgsql-9.5/bin/postgresql95-setup initdb
Initializing database ... OK
参考:https://help.ubuntu.com/stable/serverguIDe/postgresql.HTML
2.1 修改postgres用户的密码# su - postgres
-bash-4.2$ psql -U postgres
postgres=# \? -- 查看帮助
postgres=# ALTER USER postgres WITH PASSWORD '1234' --修改postgres用户的密码
postgres-# \q --退出修改
# vi /var/lib/pgsql/9.5/data/postgresql.conf
******
Listen_addresses = '*' # what IP address(es) to Listen on;
修改成以下配置
# vi /var/lib/pgsql/9.5/data/pg_hba.conf
***********
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all ::/32 md5
local replication postgres md5
#systemctlstopfirewalld
#systemctldisablefirewalld
# systemctl restart postgresql-9.5.service
总结以上是内存溢出为你收集整理的postgresql9.5 安装使用全部内容,希望文章能够帮你解决postgresql9.5 安装使用所遇到的程序开发问题。
如果觉得内存溢出网站内容还不错,欢迎将内存溢出网站推荐给程序员好友。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)