在Ubuntu2204上安装Postgresql

学习笔记
,
116 words , 1 mins.

切换到清华源

最初使用的是阿里云的源，apt 找不到 libllvm 包。

写入 /etc/apt/sources.list

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
# See http://help.ubuntu.com/community/UpgradeNotes for how to upgrade to
# newer versions of the distribution.
deb http://cn.archive.ubuntu.com/ubuntu jammy main restricted
# deb-src http://cn.archive.ubuntu.com/ubuntu jammy main restricted

## Major bug fix updates produced after the final release of the
## distribution.
deb http://cn.archive.ubuntu.com/ubuntu jammy-updates main restricted
# deb-src http://cn.archive.ubuntu.com/ubuntu jammy-updates main restricted

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
## team. Also, please note that software in universe WILL NOT receive any
## review or updates from the Ubuntu security team.
deb http://cn.archive.ubuntu.com/ubuntu jammy universe
# deb-src http://cn.archive.ubuntu.com/ubuntu jammy universe
deb http://cn.archive.ubuntu.com/ubuntu jammy-updates universe
# deb-src http://cn.archive.ubuntu.com/ubuntu jammy-updates universe

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
## team, and may not be under a free licence. Please satisfy yourself as to
## your rights to use the software. Also, please note that software in
## multiverse WILL NOT receive any review or updates from the Ubuntu
## security team.
deb http://cn.archive.ubuntu.com/ubuntu jammy multiverse
# deb-src http://cn.archive.ubuntu.com/ubuntu jammy multiverse
deb http://cn.archive.ubuntu.com/ubuntu jammy-updates multiverse
# deb-src http://cn.archive.ubuntu.com/ubuntu jammy-updates multiverse

## N.B. software from this repository may not have been tested as
## extensively as that contained in the main release, although it includes
## newer versions of some applications which may provide useful features.
## Also, please note that software in backports WILL NOT receive any review
## or updates from the Ubuntu security team.
deb http://cn.archive.ubuntu.com/ubuntu jammy-backports main restricted universe multiverse
# deb-src http://cn.archive.ubuntu.com/ubuntu jammy-backports main restricted universe multiverse

deb http://cn.archive.ubuntu.com/ubuntu jammy-security main restricted
# deb-src http://cn.archive.ubuntu.com/ubuntu jammy-security main restricted
deb http://cn.archive.ubuntu.com/ubuntu jammy-security universe
# deb-src http://cn.archive.ubuntu.com/ubuntu jammy-security universe
deb http://cn.archive.ubuntu.com/ubuntu jammy-security multiverse
# deb-src http://cn.archive.ubuntu.com/ubuntu jammy-security multiverse

安装 libllvm14

执行：

1
2
sudo apt update
sudo apt install postgresql postgresql-contrib

提示 libllvm14 包找不到，先安装改包：

1
sudo apt install libllvm14

安装 ssl-cert-snakeoil.pem

再执行安装命令，成功安装，但是启动失败：

1
2
3
4
5
6
7
8
9
● postgresql.service - PostgreSQL RDBMS
     Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
     Active: active (exited) since Fri 2023-03-31 15:42:45 UTC; 2s ago
    Process: 9793 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
   Main PID: 9793 (code=exited, status=0/SUCCESS)
        CPU: 3ms

Mar 31 15:42:45 xingzii-vm systemd[1]: Starting PostgreSQL RDBMS...
Mar 31 15:42:45 xingzii-vm systemd[1]: Finished PostgreSQL RDBMS.

到 /var/log/postgresql 查看日志，提示：

1
2
3
4
2023-03-31 15:37:02.316 UTC [9453] FATAL:  could not load server certificate file "/etc/ssl/certs/ssl-cert-snakeoil.pem": SSL error code 2147483661
2023-03-31 15:37:02.316 UTC [9453] LOG:  database system is shut down
pg_ctl: could not start server
Examine the log output.

网上看了一下，安装这个就好：

1
sudo apt install ssl-cert && sudo make-ssl-cert generate-default-snakeoil

安装好记得修改一下 /etc/ssl/certs/ssl-cert-snakeoil.pem 的权限：

1
sudo chmod 755 /etc/ssl/certs/ssl-cert-snakeoil.pem

再启动 postgresql 就好了。

验证：

1
sudo -u postgres psql -c "SELECT version();"
1
2
3
4
5
6
7
8
9
10
11
12
13
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
	LANGUAGE = (unset),
	LC_ALL = (unset),
	LC_CTYPE = "UTF-8",
	LC_TERMINAL = "iTerm2",
	LANG = "en_US.UTF-8"
    are supported and installed on your system.
perl: warning: Falling back to a fallback locale ("en_US.UTF-8").
                                                                version
----------------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 12.14 (Ubuntu 12.14-0ubuntu0.20.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit
(1 row)