CentOS 7 安装 PostgreSQL 11.4

# yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# yum install postgresql11

# yum install postgresql11-server

# /usr/pgsql-11/bin/postgresql-11-setup initdb

# systemctl enable postgresql-11

# systemctl start postgresql-11

# systemctl status postgresql-11

# su - postgres

$ psql

psql (11.4)

Type "help" for help.

 

postgres=# select * from pg_database;

  datname  | datdba | encoding | datcollate  |  datctype   | datistemplate | datallowconn | datconnlimit | datlastsysoid | datfrozenxid | datminmxid | dattablespace |

             datacl

-----------+--------+----------+-------------+-------------+---------------+--------------+--------------+---------------+--------------+------------+---------------+--

-----------------------------------

 postgres  |     10 |        6 | en_US.UTF-8 | en_US.UTF-8 | f             | t            |           -1 |         13880 |          561 |          1 |          1663 |

 template1 |     10 |        6 | en_US.UTF-8 | en_US.UTF-8 | t             | t            |           -1 |         13880 |          561 |          1 |          1663 | {

=c/postgres,postgres=CTc/postgres}

 template0 |     10 |        6 | en_US.UTF-8 | en_US.UTF-8 | t             | f            |           -1 |         13880 |          561 |          1 |          1663 | {

=c/postgres,postgres=CTc/postgres}

(3 rows)

 

postgres=#