注:使用yum方式安装有默认路径在/usr/下
查看linux服务器是什么环境
cat /etc/redhat-realese
uname -a
# postgresql install Centos7
# with Yum install
yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm -y
yum install postgresql10 postgresql10-server postgresql-contrib postgresql-devel -y
# For RHEL / CentOS / SL / OL 7 or Fedora 27 and later derived distributions:
# initdb
# 初始化数据库
/usr/pgsql-10/bin/postgresql-10-setup initdb
# 启动数据库的启动服务文件
ls /usr/lib/systemd/system/postgresql-10.service
# 设置开机启动
systemctl enable postgresql-10.service
# 启动数据库(root用户)
systemctl start postgresql-10.service
# 要切换到postgres用户才能登陆数据库
su - postgres
# 登陆数据库
-bash-4.2$ psql
psql (10.5)
Type "help" for help.
# 查看数据库
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
(3 rows)
# 寻求帮助
postgres=# \?
# 退出数据库
postgres=# \q
# 创建数据库
-bash-4.2$ createdb paojiao
# 查看帮助
-bash-4.2$ createdb --help
# 登陆数据库
-bash-4.2$ psql
# 查看刚创建的库
postgres=# \l