CentOS Learning Diary: PostgreSQL Articles

This document records the installation, configuration, use, and operation of PostgreSQL on CentOS 6.7.

First, the preparatory work

1. CentOS 6.7

2. Network OK

Second, installation

Install PostgreSQL using YUM.

Yum Install PostgreSQL

Third, initialize

After successfully installing PostgreSQL, you will need to run the following command as described on the website:

Service PostgreSQL Initdbchkconfig PostgreSQL on

These two commands are used to initialize the PostgreSQL database and to set the PostgreSQL service as self-booting.

Iv. starting the PostgreSQL database service

Service PostgreSQL Start

PostgreSQL opens port 5432 by default and can be viewed to determine if the PostgreSQL service has started properly.

NETSTAT-TULNP | grep 5432

This article is from the "Bitterjava" blog, make sure to keep this source http://rickqin.blog.51cto.com/1096449/1719816

CentOS Learning Diary: PostgreSQL Articles