安装

sudo apt update
sudo apt install postgresql postgresql-contrib
# 验证是否安装成功
sudo -u postgres psql -c "SELECT version();"

配置身份验证

passnight@passnight-s600:~$ sudo su - postgres
postgres@passnight-s600:~$ createdb sonar
postgres@passnight-s600:~$ createuser sonar
postgres@passnight-s600:~$ psql
postgres=# grant all privileges on database sonar to sonar;

配置监听端口

passnight@passnight-s600:~$ sudo vim /etc/postgresql/14/main/postgresql.conf
# listen_addresses = '*'
passnight@passnight-s600:~$ sudo vim /etc/postgresql/14/main/pg_hba.conf
# host    all             all             192.168.100.0/24        scram-sha-256
passnight@passnight-s600:~$ sudo service postgresql restart

引用