安装和配置 PostgreSQL 数据库的简单教程:
1. 安装 PostgreSQL
sudo apt update
sudo apt install postgresql postgresql-contrib -y
2. 启动 PostgreSQL 服务
sudo systemctl start postgresql
3. 设置 PostgreSQL 密码
sudo -u postgres psql -c "ALTER USER postgres WITH PASSWORD '123456';"
4. 创建数据库和表
sudo -u postgres psql -c "CREATE DATABASE xxbag;"
sudo -u postgres psql -d xxbag -c "CREATE TABLE IF NOT EXISTS t_message (
id SERIAL PRIMARY KEY,
img_url VARCHAR(255) NOT NULL,
img_time TIMESTAMP(6) NOT NULL,
cur_time TIMESTAMP(6) NOT NULL,
tag INT
);"
sudo -u postgres psql -d xxbag -c "CREATE TABLE IF NOT EXISTS send_db (
id SERIAL PRIMARY KEY,
wwid VARCHAR(255) NOT NULL,
group_index INT4 NOT NULL,
plate_number VARCHAR(255),
device_id VARCHAR(255) NOT NULL,
find_time TIMESTAMP(6) NOT NULL,
foreign_body VARCHAR(255),
send_tag VARCHAR(2) NOT NULL
);"
5. 允许远程连接和重启 PostgreSQL
echo "host all all 0.0.0.0/0 md5" | sudo tee -a /etc/postgresql/10/main/pg_hba.conf
echo "listen_addresses='*'" | sudo tee -a /etc/postgresql/10/main/postgresql.conf
sudo service postgresql restart
更多参考连接:
https://blog.csdn.net/m0_46825740/article/details/131182926