postgresql数据库备份情理
备份terminal：
pg_dump -U postgres terminal>terminal_20151228.sql
删除数据库、用户过程
\c terminal terminal
drop schema terminal cascade;
drop database terminal;
drop tablespace if exists tbs_terminal;
drop user terminal;
恢复数据库
create database terminal
psql -U postgres -d terminal -f bdc.sql
select pid,datname from pg_stat_activity where datname='terminal';
SELECT pg_cancel_backend(31941);
DETAIL: There are 8 other sessions using the database.
SELECT pg_terminate_backend(procpid) FROM pg_stat_activity WHERE procpid <> pg_backend_pid();
FROM pg_stat_activity
删除数据库、用户过程：
drop schema spider cascade;
drop database spider;
drop tablespace if exists tbs_spider;
drop user spider;
schema的导出：
导出his库里crm的schema表结构和数据(-n参数):
pg_dump -U postgres -d zhuanti -n ccs -f ccs_end_20151222.sql
\c zhuanti ccs
drop schema ccs cascade;
只导出his库里crm的schema表结构(-s参数):
pg_dump -h 192.168.2.154 -p 5432 -d his -n crm -s -f test2.sql
备份terminal：
pg_dump -U postgres terminal>terminal_20151228.sql
删除数据库、用户过程
\c terminal terminal
drop schema terminal cascade;
drop database terminal;
drop tablespace if exists tbs_terminal;
drop user terminal;
恢复数据库
create database terminal
psql -U postgres -d terminal -f bdc.sql
select pid,datname from pg_stat_activity where datname='terminal';
SELECT pg_cancel_backend(31941);
DETAIL: There are 8 other sessions using the database.
SELECT pg_terminate_backend(procpid) FROM pg_stat_activity WHERE procpid <> pg_backend_pid();
FROM pg_stat_activity
删除数据库、用户过程：
drop schema spider cascade;
drop database spider;
drop tablespace if exists tbs_spider;
drop user spider;
schema的导出：
导出his库里crm的schema表结构和数据(-n参数):
pg_dump -U postgres -d zhuanti -n ccs -f ccs_end_20151222.sql
\c zhuanti ccs
drop schema ccs cascade;
只导出his库里crm的schema表结构(-s参数):
pg_dump -h 192.168.2.154 -p 5432 -d his -n crm -s -f test2.sql
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/91975/viewspace-1965807/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
