CentOS7安装PostgreSQL10,pgadmin4
======PostgreSQL10 CentOS7=================
FYI:https://tecadmin.net/install-postgresql-server-centos/
##1 – 增加源 Add Postgres Yum Repository
rpm -Uvh https://yum.postgresql.org/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm
##2 – 安装 Install PostgreSQL 10 Server
yum install postgresql10-server postgresql10
##3 – 初始化 Initialize PGDATA
/usr/pgsql-10/bin/postgresql-10-setup initdb
... wait ... PostgreSQL data directory Path: /var/lib/pgsql/10/data/
##4 – 启动 Start PostgreSQL Server
systemctl start postgresql-10.service
systemctl enable postgresql-10.service
##5 – 验证 Verify PostgreSQL Installation
su - postgres -c "psql"
psql (10.0)
Type "help" for help.
postgres=#
##6 – 修改密码 You may create a password for user postgres for security purpose.
postgres=# \password postgres
...
======pgadmin=======================
FYI:https://people.planetpostgresql.org/devrim/index.php?/archives/96-Installing-pgAdmin4-3.X-on-RHEL-CentOS-7-and-Fedora-27.html
安装源,同postgresql...
https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm
https://yum.postgresql.org /10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm
##1 pgadmin 安装
yum install pgadmin4
##2 运行shell脚本
/usr/pgadmin4/bin/pgadmin4-web-setup.sh
输入登陆邮箱95...qq.com及密码pg123...
##3.1 For desktop mode on non-GNOME environment, please run this command:
yum (or dnf) install pgadmin4-desktop-common
##3.2 For desktop mode on GNOME environment, please run this command:
yum (or dnf) install pgadmin4-desktop-gnome
应用程序里的pgadmin快捷方式,打开,进入浏览器:
http://127.0.0.1:59240/browser/
============================
https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
https://wiki.postgresql.org/wiki/数据库对比
https://yum.postgresql.org/files/PostgreSQL-RPM-Installation-PGDG.pdf
======================================
修改数据库管理帐号postgres密码:
root下:su postgres, 然后再:psql, 进入:postgres=# (help,具体命令需要;结尾,例如)
postgres=# ALTER USER postgres WITH PASSWORD 'abc123';
ALTER ROLE
postgres=#