1.安装PostgreSQL和pgAdmin的步骤(Ubuntu)

1.安装PostgreSQL

//配置PostgreSQL官方存储库
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

//腾讯云镜像
sudo sh -c 'echo "deb https://mirrors.cloud.tencent.com/postgresql/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

//清华大学镜像
sudo sh -c 'echo "deb https://mirrors.tuna.tsinghua.edu.cn/postgresql/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

//导入存储库签名密钥
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

sudo apt-get update

//安装最新版
sudo apt-get -y install postgresql libpq-dev
//安装指定版
sudo apt-get -y install postgresql-15 libpq-dev

• PostgreSQL会创建一个名称为postgres的操作系统用户，密码被锁定。
• PostgreSQL会创建一个名称为postgres的数据库超级管理员用户，密码需用户手动配置。
• PostgreSQL会创建一个名称为postgres的数据库。

psql --version

2.安装pgAdmin

//安装pgAdmin存储库公共密钥
sudo apt install curl
sudo curl -fsS https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /usr/share/keyrings/packages-pgadmin-org.gpg

//配置pgAdmin官方存储库
sudo sh -c 'echo "deb [signed-by=/usr/share/keyrings/packages-pgadmin-org.gpg] https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

//腾讯云镜像
sudo sh -c 'echo "deb [signed-by=/usr/share/keyrings/packages-pgadmin-org.gpg] https://mirrors.cloud.tencent.com/postgresql/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

//清华大学镜像
sudo sh -c 'echo "deb [signed-by=/usr/share/keyrings/packages-pgadmin-org.gpg] https://mirrors.tuna.tsinghua.edu.cn/postgresql/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

//安装pgAdmin4(桌面和web双模式)
sudo apt install pgadmin4

//安装pgAdmin4-desktop(桌面单模式)
sudo apt install pgadmin4-desktop

//安装pgAdmin4-web(web单模式)
sudo apt install pgadmin4-web 
sudo /usr/pgadmin4/bin/setup-web.sh

3.数据库服务

//systemd命令
systemctl {start|stop|restart|status} postgresql

//service通用命令
service postgresql {start|stop|restart|status}

4.文件讲解