pg_dump不能导出访问权限 pg_dumpall可以导出访问权限
来源:互联网 发布:java帮助文档手机版 编辑:程序博客网 时间:2024/06/06 18:20
pg_dump导出,psql导入:
[highgo@hg lib]$ ./pg_dump -h localhost -U highgo --port=5866 -f my_dump.sql --inserts
[highgo@hg lib]$ psql
psql (4.0.0)
Type "help" for help.
highgo=#
highgo=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
highgo | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
template1 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | highgo=CTc/highgo+
| | | | | =c/highgo
test | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | highgo=CTc/highgo+
| | | | | =Tc/highgo
(4 rows)
highgo=# drop database test;
DROP DATABASE
highgo=# create database test;
CREATE DATABASE
highgo=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
highgo | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
template1 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | highgo=CTc/highgo+
| | | | | =c/highgo
test | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(4 rows)
highgo=# \q
[highgo@hg lib]$ pwd
/highgo/hgdb4_server/lib
[highgo@hg lib]$ pg_restore -h localhost -p 5866 -U highgo -d test --create --verbose --format custom "/highgo/hgdb4_server/lib/my_dump.sql"
pg_restore: [archiver] did not find magic string in file header
[highgo@hg lib]$ psql -h localhost -U highgo -d test < my_dump.sql
SET
SET
SET
SET
SET
SET
SET
COMMENT
CREATE EXTENSION
COMMENT
SET
SET
SET
CREATE TABLE
ALTER TABLE
ALTER TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
REVOKE
REVOKE
GRANT
GRANT
[highgo@hg lib]$ psql
psql (4.0.0)
Type "help" for help.
highgo=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
highgo | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
template1 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | highgo=CTc/highgo+
| | | | | =c/highgo
test | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(4 rows)
highgo=#
========================================================================================
========================================================================================
pg_dumpall导出,psql导入:
./pg_dumpall -h localhost -U highgo --port=5866 -f my_dumpall.sql --inserts
[highgo@hg lib]$ psql
psql (4.0.0)
Type "help" for help.
highgo=#
highgo=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
highgo | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
template1 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
test | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/highgo +
| | | | | highgo=CTc/highgo
(4 rows)
highgo=# drop database test;
DROP DATABASE
highgo=# create database test;
CREATE DATABASE
highgo=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
highgo | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
template1 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
test | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(4 rows)
highgo=# CREATE ROLE highgo;
ERROR: 42710: role "highgo" already exists
highgo=# ALTER ROLE highgo WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION BYPASSRLS;
ALTER ROLE
highgo=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
highgo | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
template1 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
test | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(4 rows)
highgo=# ALTER ROLE test WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS PASSWORD 'md505a671c66aefea124cc08b76ea6d30bb';
ALTER ROLE
highgo=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
highgo | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
template1 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
test | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(4 rows)
highgo=# \q
[highgo@hg lib]$ psql -h localhost -U highgo -d test < my_dumpall.sql
SET
SET
SET
ERROR: 42710: role "aaa" already exists
ALTER ROLE
ERROR: 42710: role "highgo" already exists
ALTER ROLE
ERROR: 42710: role "test" already exists
ALTER ROLE
ERROR: 42P04: database "highgo" already exists
REVOKE
REVOKE
GRANT
GRANT
ERROR: 42P04: database "test" already exists
REVOKE
REVOKE
GRANT
GRANT
You are now connected to database "highgo" as user "highgo".
SET
SET
SET
SET
SET
SET
SET
SET
COMMENT
CREATE EXTENSION
COMMENT
SET
SET
SET
ERROR: 42P07: relation "test" already exists
ALTER TABLE
ALTER TABLE
INSERT 0 1
INSERT 0 1
REVOKE
REVOKE
GRANT
GRANT
You are now connected to database "template1" as user "highgo".
SET
SET
SET
SET
SET
SET
SET
SET
COMMENT
CREATE EXTENSION
COMMENT
REVOKE
REVOKE
GRANT
GRANT
You are now connected to database "test" as user "highgo".
SET
SET
SET
SET
SET
SET
SET
SET
CREATE EXTENSION
COMMENT
REVOKE
REVOKE
GRANT
GRANT
[highgo@hg lib]$ psql
psql (4.0.0)
Type "help" for help.
highgo=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
highgo | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
template1 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | highgo=CTc/highgo+
| | | | | =c/highgo
test | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | highgo=CTc/highgo+
| | | | | =Tc/highgo
(4 rows)
highgo=#
[highgo@hg lib]$ ./pg_dump -h localhost -U highgo --port=5866 -f my_dump.sql --inserts
[highgo@hg lib]$ psql
psql (4.0.0)
Type "help" for help.
highgo=#
highgo=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
highgo | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
template1 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | highgo=CTc/highgo+
| | | | | =c/highgo
test | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | highgo=CTc/highgo+
| | | | | =Tc/highgo
(4 rows)
highgo=# drop database test;
DROP DATABASE
highgo=# create database test;
CREATE DATABASE
highgo=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
highgo | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
template1 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | highgo=CTc/highgo+
| | | | | =c/highgo
test | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(4 rows)
highgo=# \q
[highgo@hg lib]$ pwd
/highgo/hgdb4_server/lib
[highgo@hg lib]$ pg_restore -h localhost -p 5866 -U highgo -d test --create --verbose --format custom "/highgo/hgdb4_server/lib/my_dump.sql"
pg_restore: [archiver] did not find magic string in file header
[highgo@hg lib]$ psql -h localhost -U highgo -d test < my_dump.sql
SET
SET
SET
SET
SET
SET
SET
COMMENT
CREATE EXTENSION
COMMENT
SET
SET
SET
CREATE TABLE
ALTER TABLE
ALTER TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
REVOKE
REVOKE
GRANT
GRANT
[highgo@hg lib]$ psql
psql (4.0.0)
Type "help" for help.
highgo=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
highgo | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
template1 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | highgo=CTc/highgo+
| | | | | =c/highgo
test | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(4 rows)
highgo=#
========================================================================================
========================================================================================
pg_dumpall导出,psql导入:
./pg_dumpall -h localhost -U highgo --port=5866 -f my_dumpall.sql --inserts
[highgo@hg lib]$ psql
psql (4.0.0)
Type "help" for help.
highgo=#
highgo=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
highgo | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
template1 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
test | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/highgo +
| | | | | highgo=CTc/highgo
(4 rows)
highgo=# drop database test;
DROP DATABASE
highgo=# create database test;
CREATE DATABASE
highgo=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
highgo | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
template1 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
test | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(4 rows)
highgo=# CREATE ROLE highgo;
ERROR: 42710: role "highgo" already exists
highgo=# ALTER ROLE highgo WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION BYPASSRLS;
ALTER ROLE
highgo=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
highgo | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
template1 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
test | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(4 rows)
highgo=# ALTER ROLE test WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS PASSWORD 'md505a671c66aefea124cc08b76ea6d30bb';
ALTER ROLE
highgo=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
highgo | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
template1 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
test | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(4 rows)
highgo=# \q
[highgo@hg lib]$ psql -h localhost -U highgo -d test < my_dumpall.sql
SET
SET
SET
ERROR: 42710: role "aaa" already exists
ALTER ROLE
ERROR: 42710: role "highgo" already exists
ALTER ROLE
ERROR: 42710: role "test" already exists
ALTER ROLE
ERROR: 42P04: database "highgo" already exists
REVOKE
REVOKE
GRANT
GRANT
ERROR: 42P04: database "test" already exists
REVOKE
REVOKE
GRANT
GRANT
You are now connected to database "highgo" as user "highgo".
SET
SET
SET
SET
SET
SET
SET
SET
COMMENT
CREATE EXTENSION
COMMENT
SET
SET
SET
ERROR: 42P07: relation "test" already exists
ALTER TABLE
ALTER TABLE
INSERT 0 1
INSERT 0 1
REVOKE
REVOKE
GRANT
GRANT
You are now connected to database "template1" as user "highgo".
SET
SET
SET
SET
SET
SET
SET
SET
COMMENT
CREATE EXTENSION
COMMENT
REVOKE
REVOKE
GRANT
GRANT
You are now connected to database "test" as user "highgo".
SET
SET
SET
SET
SET
SET
SET
SET
CREATE EXTENSION
COMMENT
REVOKE
REVOKE
GRANT
GRANT
[highgo@hg lib]$ psql
psql (4.0.0)
Type "help" for help.
highgo=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
highgo | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/highgo +
| | | | | highgo=CTc/highgo
template1 | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | highgo=CTc/highgo+
| | | | | =c/highgo
test | highgo | UTF8 | en_US.UTF-8 | en_US.UTF-8 | highgo=CTc/highgo+
| | | | | =Tc/highgo
(4 rows)
highgo=#
阅读全文
0 0
- pg_dump不能导出访问权限 pg_dumpall可以导出访问权限
- 网页导出excel文件无访问权限的问题
- 设置androidstudio中模拟器数据库导出和Data访问权限
- PG数据库之间的导入导出(pg_dumpall,pg_dump,psql,pg_restore)
- 可以访问tomcat主页,不能访问项目(tomcat的写入权限不够)
- 可以访问tomcat主页,不能访问项目(tomcat的写入权限不够)
- 访问权限
- 访问权限
- 访问权限
- 访问权限
- 访问权限
- 访问权限
- 访问权限
- 访问权限
- 访问权限
- 访问权限
- 访问权限
- 访问权限
- 算法提高 ADV-156 分分钟的碎碎念
- 数据挖掘 日期转换表
- 1083: 数值统计(多实例测试)
- 车牌识别相机的算法开发与调用例程
- 第二周——项目二—程序的多文件组织
- pg_dump不能导出访问权限 pg_dumpall可以导出访问权限
- HDU 2846(Tire的变形)
- Nginx负载均衡配置简易实现
- 练习7-2重循环
- pg备份相关知识点
- 快速排序
- 自定义JavaScript轮播组件
- php仅连接到mysql服务器的代码实现
- 算法提高 ADV-170 数字黑洞