1、先删除旧的版本postgresql，
sudo apt-get --purge remove postgresql*
2、安装postgresql
# Create the file repository configuration:
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
# Import the repository signing key:
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
# Update the package lists:
sudo apt-get update
# Install the latest version of PostgreSQL.
# If you want a specific version, use 'postgresql-12' or similar instead of 'postgresql':
sudo apt-get -y install postgresql
3、进入psql，创建用户,注意最后分号,如果数据库名称不加双引号，则视为全部小写
create user zygd with password 'password';
create database "WeatherSys" owner zygd;
grant all privileges on database WeatherSys to zygd;
4、更改postgresql.conf配置文件将listen localhost改为*
将 #listen_addresses = 'localhost' 的注释去掉并改为 listen_addresses = '*'
b. 修改可访问用户的IP段
vim /etc/postgresql/9.5/main/pg_hba.conf在文件末尾添加： host all all 0.0.0.0 0.0.0.0 md5 ，表示运行任何IP连接
重启数据库/etc/init.d/postgresql restart
还原
1 su username
2 cd ./usr/...
3 pg_restore -d "SoilMoistureSys" -F c ./12.sql
更换data存放路径
创建数据存储目录
$mkdir -p /data/postgresql
停止服务
$sudo service postgresql stop
复制数据
$sudo cp -rf /var/lib/postgresql/9.6/main/ /data/postgresql/
权限设置
$sudo chown -R postgres:postgres /data/postgresql/
$sudo chmod 700 /data/postgresql/
更改配置文件
$sudo vim /etc/postgresql/9.6/main/postgresql.conf
data_directory = '/data/postgresql/main'
启动服务
$sudo service postgresql start
Run pg_lsclusters from your terminal
pg_ctlcluster 12 main start
