ubuntu 18 虚拟机安装（5） postgres sql 数据库 简单 应用

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();