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