Install PostgreSQL

Go to the PostgreSQL repository download page , and add the PostgreSQL 9.4 repository depending upon your server architecture.

For CentOS 6.x 32bit:

rpm -Uvh http://yum.postgresql.org/9.4/redhat/rhel-6-i386/pgdg-centos94-9.4-1.noarch.rpm

For CentOS 6.x 64bit:

rpm -Uvh http://yum.postgresql.org/9.4/redhat/rhel-6-x86_64/pgdg-centos94-9.4-1.noarch.rpm

For CentOS 7 64bit:

rpm -Uvh http://yum.postgresql.org/9.4/redhat/rhel-7-x86_64/pgdg-centos94-9.4-1.noarch.rpm

Update the repository list using command:

yum update

Now, Install postgresql with the following command:

yum install postgresql94-server postgresql94-contrib

Initialize postgresql database using following command:

On CentOS 6.x systems:

service postgresql-9.4 initdb

On CentOS 7 systems:

/usr/pgsql-9.4/bin/postgresql94-setup initdb

Then, start postgresql service and make it to start automatically on every reboot.

On CentOS 6.x systems:

service postgresql-9.4 start
chkconfig postgresql-9.4 on

On CentOS 7 systems:

systemctl enable postgresql-9.4
systemctl start postgresql-9.4
Adjust Iptables/Firewall

Next, adjust iptables to access postgresql from remote systems.

On CentOS 6.x systems:

vi /etc/sysconfig/iptables

Add the following line:

-A INPUT -m state --state NEW -m tcp -p tcp --dport 5432 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT

Save and exit the file. Restart iptables service.

service iptables restart

On CentOS 7 systems:

firewall-cmd --permanent --add-port=5432/tcp
firewall-cmd --permanent --add-port=80/tcp
firewall-cmd --reload
Access PostgreSQL command prompt

The default database name and database user are “postgres” . Switch to postgres user to perform postgresql related operations:

su - postgres

To login to postgresql, enter the command:

psql
Sample Output:
psql (9.4.0)
Type "help" for help.
postgres=#
To exit from posgresql prompt, type \q following by quit to return back to the Terminal.
pgadmin4 新建服务器出现错误: Peer authentication failed for user "postgres"

# vim /var/lib/pgsql/9.6/data/pg_hba.conf

在该配置文件的host all all 127.0.0.1/32 md5行下添加以下配置,或者直接将这一行修改为以下配置

host all all 0.0.0.0/0 md5

# vim /var/lib/pgsql/9.6/data/postgresql.conf

将该文件中的listen_addresses项值设定为“*”,在9.0 windows版中,该项配置已经是“*”无需修改。

# service postgresql-9.6 restart

注:通过本机命令行出现: Peer authentication failed for user "postgres"

# vim /var/lib/pgsql/9.6/data/postgresql.conf

#local all all peer

local all all md5

pgadmin4 新建服务器出现错误: fe_sendauth: no password supplied

# su - postgres

postgres=# ALTER USER postgres WITH PASSWORD 'password';

ALTER ROLE

postgres=# \q

# service postgresql-9.6 restart

本文数据库(mssql)相关术语:熊片数据库 mssql数据库 oracle数据库 pubmed数据库 access数据库 万方数据库

主题: 服务器PostgreSQLSQL数据WindowsUT数据库LG
分页:12
转载请注明
本文标题:CentOSInstallpostgresql9.6 CentOS CentOS服务器 postgresql 数据库安装
本站链接:http://www.codesec.net/view/520436.html
分享请点击:


1.凡CodeSecTeam转载的文章,均出自其它媒体或其他官网介绍,目的在于传递更多的信息,并不代表本站赞同其观点和其真实性负责;
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性,不作出任何保证或承若;
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
登录后可拥有收藏文章、关注作者等权限...
技术大类 技术大类 | 数据库(mssql) | 评论(0) | 阅读(49)