简介
关系型数据库
安装及操作(ubuntu)
- sudo apt-get update
- sudo apt-get install postgresql postgresql-client
- sudo -u postgres psql
- /usr/lib/postgresql/10/bin 导入和导出数据(注意!命令导入前需要创建数据库)
导入:./psql -U postgres db < /root/111.sql
导出:./pg_dump -U postgres db > /root/111.sql - 进入数据库:\c + 数据库名
- 查看所有的表:select * from pg_tables;
在执行过程中遇到的问题:
error:psql: FATAL: Peer authentication failed for user “postgres”
resolve:
(1) sudo vim /etc/postgresql/11/main/pg_hba.conf
(2)将# Database administrative login by Unix domain socket
local all postgres peer
修改为# Database administrative login by Unix domain socket
local all postgres trust
(3)sudo /etc/init.d/postgresql reload