pg_dump导出psql导入举例
来源:互联网 发布:oracle创建数据库语句 编辑:程序博客网 时间:2024/06/07 03:10
备份:
[postgres9.6@db bin]$ pg_dump -h localhost -U postgres9.6 test > /tmp/test.bak
恢复:
postgres# drop database test;
DROP DATABASE
[postgres9.6@db tmp]$ psql -h localhost -U postgres9.6 -d test < /tmp/test.bak
psql: FATAL: database "test" does not exist
postgres# create database test;
CREATE DATABASE
[postgres9.6@db tmp]$ psql -h localhost -U postgres9.6 -d test < /tmp/test.bak
Null display is "NULL".
Pager is always used.
Timing is on.
SET
Time: 0.137 ms
SET
Time: 0.444 ms
SET
Time: 0.085 ms
SET
Time: 0.069 ms
SET
Time: 0.072 ms
SET
Time: 0.060 ms
SET
Time: 0.060 ms
SET
Time: 0.058 ms
CREATE SCHEMA
Time: 5.376 ms
ALTER SCHEMA
Time: 4.268 ms
CREATE SCHEMA
Time: 1.322 ms
ALTER SCHEMA
Time: 4.456 ms
CREATE EXTENSION
Time: 1.637 ms
COMMENT
Time: 1.165 ms
SET
Time: 0.180 ms
SET
Time: 0.106 ms
SET
Time: 0.067 ms
CREATE TABLE
Time: 9.446 ms
ALTER TABLE
Time: 4.524 ms
SET
Time: 0.372 ms
CREATE TABLE
Time: 4.539 ms
ALTER TABLE
Time: 1.581 ms
SET
Time: 4.129 ms
COPY 6
Time: 3.604 ms
SET
Time: 0.110 ms
COPY 0
Time: 0.192 ms
SET
Time: 0.061 ms
GRANT
Time: 1.086 ms
[postgres9.6@db tmp]$
[postgres9.6@db tmp]$ psql test a
Null display is "NULL".
Pager is always used.
Timing is on.
psql (9.6.1)
Type "help" for help.
a@[local]:5432 test# select * from test;
id
----
1
1
1
1
1
1
(6 rows)
Time: 0.795 ms
[postgres9.6@db tmp]$ pg_restore --host localhost --port 5432 --username "postgres9.6" --dbname "test" --no-password --verbose "/tmp/test.bak"
pg_restore: [archiver] input file appears to be a text format dump. Please use psql.
一个数据库(或者部分对象)导出为脚本文本文件,用psql恢复。
一个数据库(或者部分对象)导出为归档文件,用pg_restore恢复。
[postgres9.6@db bin]$ pg_dump -h localhost -U postgres9.6 test > /tmp/test.bak
恢复:
postgres# drop database test;
DROP DATABASE
[postgres9.6@db tmp]$ psql -h localhost -U postgres9.6 -d test < /tmp/test.bak
psql: FATAL: database "test" does not exist
postgres# create database test;
CREATE DATABASE
[postgres9.6@db tmp]$ psql -h localhost -U postgres9.6 -d test < /tmp/test.bak
Null display is "NULL".
Pager is always used.
Timing is on.
SET
Time: 0.137 ms
SET
Time: 0.444 ms
SET
Time: 0.085 ms
SET
Time: 0.069 ms
SET
Time: 0.072 ms
SET
Time: 0.060 ms
SET
Time: 0.060 ms
SET
Time: 0.058 ms
CREATE SCHEMA
Time: 5.376 ms
ALTER SCHEMA
Time: 4.268 ms
CREATE SCHEMA
Time: 1.322 ms
ALTER SCHEMA
Time: 4.456 ms
CREATE EXTENSION
Time: 1.637 ms
COMMENT
Time: 1.165 ms
SET
Time: 0.180 ms
SET
Time: 0.106 ms
SET
Time: 0.067 ms
CREATE TABLE
Time: 9.446 ms
ALTER TABLE
Time: 4.524 ms
SET
Time: 0.372 ms
CREATE TABLE
Time: 4.539 ms
ALTER TABLE
Time: 1.581 ms
SET
Time: 4.129 ms
COPY 6
Time: 3.604 ms
SET
Time: 0.110 ms
COPY 0
Time: 0.192 ms
SET
Time: 0.061 ms
GRANT
Time: 1.086 ms
[postgres9.6@db tmp]$
[postgres9.6@db tmp]$ psql test a
Null display is "NULL".
Pager is always used.
Timing is on.
psql (9.6.1)
Type "help" for help.
a@[local]:5432 test# select * from test;
id
----
1
1
1
1
1
1
(6 rows)
Time: 0.795 ms
[postgres9.6@db tmp]$ pg_restore --host localhost --port 5432 --username "postgres9.6" --dbname "test" --no-password --verbose "/tmp/test.bak"
pg_restore: [archiver] input file appears to be a text format dump. Please use psql.
一个数据库(或者部分对象)导出为脚本文本文件,用psql恢复。
一个数据库(或者部分对象)导出为归档文件,用pg_restore恢复。
阅读全文
0 0
- pg_dump导出psql导入举例
- PG数据库之间的导入导出(pg_dumpall,pg_dump,psql,pg_restore)
- psql copy命令导入导出数据
- PostgreSQL pg_dump&pg_restore 数据的导出和导入
- psql、pg_dump带密码执行sql语句
- PostgreSQL pg_dump&psql 数据的备份与恢复
- PostgreSQL pg_dump&psql 数据的备份与恢复
- PostgreSQL pg_dump&psql 数据的备份与恢复
- pg_dump
- PostgreSQL数据库导出命令pg_dump详解
- PostgreSQL数据库导出命令pg_dump详解
- pg_dump的导出参数(PostgreSQL)
- pg_dump 导出文件过大的解决办法
- PostgreSQL数据库导出命令pg_dump详解
- Mysql工具mysqldump导出、导入用法举例详解
- Mysql工具mysqldump导出、导入用法举例详解
- mysql账号增删改、数据导入导出命令举例
- pg_dump不能导出访问权限 pg_dumpall可以导出访问权限
- 设计模式(二)——工厂设计模式(1)
- javaweb刷新和不缓存
- 1086: ASCII码排序(多实例测试)
- Java中ArrayList remove会遇到的坑
- POJ 3164 Command Network (最小树形图)
- pg_dump导出psql导入举例
- 数据结构第二周项目3(1)--体验复杂度之两种排序算法的运行时间
- 前端分页案例
- POJ 1144 Network (无向图求割点)
- KMP算法查找相同字符串
- 第二周项目--函数参数传值的几种方式
- js-return ture to win
- 算法提高 ADV-179 解二元一次方程组
- 浅析MySQL中exists与in的使用 (写的非常好)