ubuntu 18 虚拟机安装（5） postgres sql 数据库 简单 应用
参考
PostgreSQL的基本使用整理
https://blog.csdn.net/qq_45658339/article/details/124431612
sudo su - postgres
psql
sudo -u postgres psql
sudo systemctl status postgresql
sudo systemctl start postgresql
sudo systemctl stop postgresql
添加用户
执行这句话的时候，一定要注意查看，当前是否是测试环境
drop role jack ;
create user jack with password '12345' superuser;
select * from pg_user;
pg_dump
pg_dump -h 127.0.0.1 -U jack-d abc -f abc_bak_2024_06_28.sql
11
pg_dump -U kms -h 127.0.0.1 -b -v -Fc -f /root/psql_bak/kms_2024_06_28.back kms
pg_dump -U kms -h 127.0.0.1 -b -Fc -f /root/psql_bak/kh_data_2024_06_28.back kh_data
create user abc with password '123456' ;
sudo -u postgres psql
create database kh_data owner kms;
\c kh_data;
CREATE EXTENSION IF NOT EXISTS timescaledb;
SELECT timescaledb_pre_restore();
\q
pg_restore -h 127.0.0.1 -U kms -p 5432 -j 3 -v -d kh_data /home/jack/sql_bak/kh_data_2024_06_28.back
sudo -u postgres psql
\c kh_data;
SELECT timescaledb_post_restore();
