Use of the "PostgreSQL" CentOS Environment

Installation:

Yum install Postgresql-serverservice PostgreSQL initdbchkconfig PostgreSQL on

PostgreSQL by default, remote Access does not succeed, and if you need to allow remote access, you need to modify two configuration files, as described below:

# Modify the database password of the Postgres user by logging in to the database Postgres user

Psql-u Postgres
postgres=# ALTER USER postgres PASSWORD ' 123456 ';
postgres=# \q

# Edit the configuration file, configure the network address that can access the database

(Be careful not to forget to remove the # in front of #listen_addresses=)

vim/var/lib/pgsql/data/postgresql.conflisten_addresses = ' * '

　　

# Edit config file, set password MD5 authentication

Host All 0.0.0.0/0 MD5

Use of the "PostgreSQL" CentOS Environment