postgresql psql usage.

Login

docker exec -it postgres psql -h 127.0.0.1 -p 5432 -U nevan -d nevan
PGPASSWORD="admin" psql -h 127.0.0.1 -p 5432 -U nevan -d nevan

Create DB

sudo -u postgres psql

CREATE USER nevan WITH PASSWORD 'admin' CREATEDB;
CREATE DATABASE nevan TEMPLATE template0 ENCODING 'UTF8';
ALTER DATABASE nevan OWNER TO nevan;
GRANT ALL PRIVILEGES ON DATABASE nevan TO nevan;

Backup

pg_dump.sh

#!/bin/bash
#pg_dump -c -C --dbname=postgresql://nevan:nevan@127.0.0.1:5432/nevan > /root/DB/nevan_$(date +%F-%R).sql
#pg_dump -c -C --dbname=postgresql://nevan:nevan@127.0.0.1:5432/nevan > /root/DB/nevan.sql
#PGPASSWORD="admin" pg_dump -c -C -d nevan -h 127.0.0.1 -p 5432 -U nevan -F t -f /root/DB/nevan.tar

docker exec postgres pg_dump -c -C -d nevan -h 127.0.0.1 -p 5432 -U nevan -F t -f /backup/nevan.tar

pg_restore.sh

#!/bin/bash
#PGPASSWORD="admin" pg_restore -c -d nevan -h 127.0.0.1 -p 5433 -U nevan -F t /root/DB/nevan.tar
docker exec postgres pg_restore -c -d nevan -h 127.0.0.1 -p 5432 -U nevan -F t /backup/nevan.tar

清空数据库

DROP SCHEMA public CASCADE;
CREATE SCHEMA public;

PostgreSQL操作-psql基本命令 - Halo3224 - 博客园
https://www.cnblogs.com/my-blogs-for-everone/p/10226473.html

https://www.cnblogs.com/nhdlb/p/14960000.html

标签：postgresql, psql, database, vps

你的评论