思维导图

root@server10:~# curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | gpg –dearmor | sudo tee /usr/share/keyrings/postgresql-key.gpg >/dev/null 下载postgresql数据库的gpg的密钥

  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current

                                 Dload  Upload   Total   Spent    Left  Speed

100  4812  100  4812    0     0   3034      0  0:00:01  0:00:01 –:–:–  3034

root@server10:~#

sudo sh -c ‘echo “deb [signed-by=/usr/share/keyrings/postgresql-key.gpg arch=amd64] http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main” > /etc/apt/sources.list.d/pgdg.list’   

将postgresql存储库添加到ubuntu24.04系统中

root@server10:~# curl -fsSL https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg –dearmor -o /usr/share/keyrings/pgadmin4.gpg

下载pgadmin4存储库gpg的密钥

File ‘/usr/share/keyrings/pgadmin4.gpg’ exists. Overwrite? (y/N) y

root@server10:~#

root@server10:~# sudo echo “deb [arch=amd64 signed-by=/usr/share/keyrings/pgadmin4.gpg] https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main”\

| sudo tee /etc/apt/sources.list.d/pgadmin4.list                                                  将pgadmin4添加到ubuntu系统中

deb [arch=amd64 signed-by=/usr/share/keyrings/pgadmin4.gpg] https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/noble pgadmin4 main

root@server10:~#

root@server10:~# apt update 更新数据源

root@server10:~# apt install pgadmin4-web    安装pgadmin4-web客户端

root@server100:~# apt install postgresql postgresql-contrib 安装postgresql数据库

root@server100:~# systemctl is-enabled postgresql 重启postgresql数据库，并设置（Ubuntu系统）开机启动

enabled

root@server100:~# systemctl status postgresql 查看postgresql数据库的状态

● postgresql.service – PostgreSQL RDBMS

     Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; preset: enabled)

     Active: active (exited) since Mon 2025-02-10 09:54:11 CST; 34s ago

   Main PID: 11615 (code=exited, status=0/SUCCESS)

        CPU: 1ms

Feb 10 09:54:11 server100 systemd[1]: Starting postgresql.service – PostgreSQL RDBMS…

Feb 10 09:54:11 server100 systemd[1]: Finished postgresql.service – PostgreSQL RDBMS.

root@server100:~#

root@server100:~#

root@server100:~# sudo -u postgres psql 登录postgresql数据库

psql (17.2 (Ubuntu 17.2-1.pgdg24.04+1))

Type “help” for help.

postgres=# CREATE role alice WITH SUPERUSER CREATEROLE LOGIN ENCRYPTED PASSWORD ‘alicepassword’;

创建alice角色，并设置成超级用户；创建角色的登录加密密码为alicepassword

CREATE ROLE

postgres=# \du 查询数据库的用户列表

                             List of roles

 Role name |                         Attributes                         

———–+————————————————————

 alice     | Superuser, Create role

 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS

postgres=# CREATE DATABASE alice; 创建alice数据库

CREATE DATABASE

postgres=# GRANT ALL PRIVILEGES ON DATABASE alice TO alice; 将alice数据库全部授权给alice用户

GRANT

postgres=# \l 查看列表

postgres=# \q 退出（专用语法，其他数据库不用）

root@server100:~# apt install pgadmin4-web                                        安装pgadmin4-web客户端

root@server100:~# /usr/pgadmin4/bin/setup-web.sh                                     运行pgadmin的安装脚本

Setting up pgAdmin 4 in web mode on a Debian based platform…

Creating configuration database…

NOTE: Configuring authentication for SERVER mode.