Install Postgresql

Go to the Postgresql repositorydownload 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.

service postgresql-9.4 start chkconfig postgresql-9.4 on

systemctl enable postgresql-9.4 systemctl start postgresql-9.4

Adjust Iptables/Firewall

Next,adjust iptables to access postgresql from remote 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

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\qfollowing byquitto return back to the Terminal.

pgadmin4新建服务器出现错误: Peer authentication Failed for user "postgres"

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

@H_502_118@ 在该配置文件的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

@H_403_139@# service postgresql-9.6 restart

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

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

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

@H_403_139@# su - postgres

@H_403_139@

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

@H_403_139@

@H_403_139@ALTER ROLE

@H_403_139@postgres=# \q

@H_403_139@# service postgresql-9.6 restart

原文链接：https://www.f2er.com/centos/379162.html